How to create a User login RRS feed

  • Question

  •    hi,

    i want to create a user login on my SQL server,i am not much fimilar with the security tab.

    how can i create a user with resitction. this user is only allow to view one database on that server as well as in that database he's only hv access to see the tables of that database. this user is only have read only permission..

    i don't have any schema defined on my server as well as on any database..
    Please do help me how can i create such a user.
    • Moved by Mangal Pardeshi Thursday, March 12, 2009 9:20 AM (Moved from Transact-SQL to SQL Server Security)
    Thursday, March 12, 2009 8:58 AM


All replies