Click here to Skip to main content
16,020,669 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi,

I have a table AcoTransaction. With Schema dbo.
I want to hide the Table AcoTransaction on object explorer so that any user cannot view on object explorer but can run script if they know the table name.
Posted
Comments
Stephen Hewison 25-Jan-16 6:17am    
I don't think this can be done. I think you can stop a user seeing it whilst still being able to execute stored procedures which access it. But if you can directly execute any script against the table you must be able to see it.

1 solution

You can't hide a table but you can not grant permission to view the contents based on the user who is logged in.
GRANT Object Permissions (Transact-SQL)[^]
 
Share this answer
 
Comments
phil.o 25-Jan-16 6:27am    
"You cannot hide [...] but you cannot grant [...]"
This opposition is misleading, imho :)
Mehdi Gholam 25-Jan-16 7:08am    
...can, not... :)
phil.o 25-Jan-16 7:13am    
I'm sorry, but I still do not see the distinction between both forms :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900