Post reply

Single user Access Multiple databases in SQL 2005

  • July 8, 2008 at 8:25 pm

    #193536

    Hi,

    I have created a single database user that can access a database in sql 2005. I want the same user to give access to another database on the same machine running SQL 2005.

    e.g. sql 2005 management studio contains following databases.

    DBMachine\MSSQL

    Databases

    + System Databases

    + Databaseone

    + Databasetwo

    +Databasethree

    user test created with access on Databaseone. I want the test user to access Databasetwo and Databasethree as well .

    test user can create, view, update, delete, select etc tables, views , stored procedures etc. I dont want test user to be dbo.?

    How can i do it? Please let me know as i have no experience of handling it.?

    Thanks & Regards

  • July 9, 2008 at 1:22 pm

    #840474

    GRANT db_ddladmin, db_datareader, and db_datawriter. If you would like the user has permission to execute stored procedure, you may grant EXECUTE permission to it. If you would like the user has authority to grant others permission, you may grant db_securityadmin to it. ...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply