I need urgent help regarding permissions:
How can i apply Deny Permission regarding sys.database and sys.tables etc to users ?
Restrict the the user for viewing,updating,inserting,selection and creation of tables ,stored procedures,views ?
Restrict user to access only specified database ?
I have done above successfully except below :
Restrict user to excute query like i.e. select * from sys.database or sys.tables and any other query that user can execute and know the database schema ?
as users can get list of tables and known the column names which i can't allow.
Windows authentication not allowed ?
kindly help me out :(
Loading
Blocked AccountPosted Jan 2, 2013, 12:32 AM
You should be able to just deny permissions on the entire sys and information_schema schema as a whole:
DENY SELECT On SCHEMA::sys To [user_name]
DENY SELECT On SCHEMA::INFORMATION_SCHEMA To [user_name]