Madiha Rehman

Madiha Rehman

  • NA
  • 1
  • 2.7k

Restrict user to select * from sys.tables,sys.databases ?

Jan 2 2013 12:23 AM
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 :(

Answers (1)