logins

• nikki123

  Ten Centuries

  Points: 1338

  More actions

  January 5, 2010 at 8:46 am

  #228881

  I have created a particular login . I have given the database level permisisons .

  I can only see the system tables not the other tables which the database has.

  Please help me with this issue

• josantia

  Ten Centuries

  Points: 1255

  More actions

  January 5, 2010 at 9:01 am

  #1099017

  Hi Nikki,

  You have to have permissions (any) in order to see anything else, this is new from SQL 2005.

  You can try with:

  USE <your_db>

  GO

  GRANT VIEW DEFINITION TO <user>

  Which will grant the permissions to view all the objects in the DB.

  Regards,

  Jose Santiago Oyervides.