May 19, 2008 at 2:19 pm
I have a user who can login the server, see the databases, but he is unable to see any tables in the database. It looks like there is no tables into the database from his side. Any one knows what might be the persmission i need to give him so that he can view all the tables.
From my side i can see all the tables.
May 19, 2008 at 3:15 pm
You can add this user to db_datareader database role to read everything in the database, or if you would like the user just to review the schema but not data, you can grant specific permissions like View Definition permission:
http://msdn.microsoft.com/en-us/library/ms188629.aspx
db_datareader
http://msdn.microsoft.com/en-us/library/ms175808.aspx
VIEW DEFINITION Permission
http://msdn.microsoft.com/en-us/library/ms178569.aspx
GRANT Database Permissions (Transact-SQL)
Regards,Yelena Varsha
May 19, 2008 at 3:25 pm
I resolved it, here it was the problem as the user wasnt correctly mapped with the read permissions. Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply