TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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 :(
Reply
Answers (
1
)
how to show row by moving between table rows using procedure
SQL Query