Restrict user to select * from sys.tables,sys.databases ?
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 :(