I have sql server user in the database and for some reason, user is not able to view the tables when connecting
here are the commands that i am using to create that user. I do not want to make the user 'dbuser' the owner of the schema.
even though i am granting all insert and update tec access on the schema.. the user when logged in with 'dbuser' is not able to view the any of the tables from any of the schemasw. He just sees the systemtables tab whe the user tries to connect to the database.User needs to see all the tables under the schema1,schema2, schema3
The basic structure of creating a user:
Have you got statement 2 in the right place, ie before creating the user within the DB?
answered Jul 11, 2011 at 02:40 PM
I'm guessing that you mean the user is not able to view a list of the tables in the SSMS GUI tree. You might need to grant view definition (http://msdn.microsoft.com/en-us/library/ms175808.aspx).
Confirm that the user is in fact able to query the tables themselves. Additionally confirm that you have created the login on the server.
answered Jul 11, 2011 at 03:57 PM