Results 1 to 4 of 4

Thread: rights issue

  1. #1
    Join Date
    Oct 2004
    Posts
    12

    Unhappy Unanswered: rights issue

    How do I text base add my domain users group with full rights to my database. I am using teratrax to manage my database. This is what comes up when I click on new database user

    -- Replace all lower case words with your own code.

    EXECUTE SP_GRANTDBACCESS 'login', 'user_name'

  2. #2
    Join Date
    Jan 2005
    Posts
    8
    Hi,

    with that statement you posted you only grant database access for an user. The user cannot do anything in your database if you don't grant him further permissions. What exactly do you mean with full rights? Systemadministrators' rights? Or are DBOwner-Rights sufficient?

    Otherwise you should create a role which has specific rights in your databases and add the users group to that role.


  3. #3
    Join Date
    Oct 2004
    Posts
    12

    rights issue2

    Yeah DBOWNER would be enough rights. How do I add roles and then how do I add domain users group to them?

  4. #4
    Join Date
    Jan 2005
    Posts
    8
    To create a new role use:

    sp_addrole [ @rolename = ] 'role'
    [ , [ @ownername = ] 'owner' ]


    in the specific database.

    Grant Permissions to that role for each object needed:

    GRANT
    { ALL [ PRIVILEGES ] | permission [ ,...n ] }
    {
    [ ( column [ ,...n ] ) ] ON { table | view }
    | ON { table | view } [ ( column [ ,...n ] ) ]
    | ON { stored_procedure | extended_procedure }
    | ON { user_defined_function }
    }
    TO security_account [ ,...n ]
    [ WITH GRANT OPTION ]
    [ AS { group | role } ]


    To add a user or group to a role use:

    sp_addrolemember [ @rolename = ] 'role' ,
    [ @membername = ] 'security_account'


    in the specific database.

    To add a user/group to the db_owner role use:

    sp_addrolemember [ @rolename = ] 'db_owner' ,
    [ @membername = ] 'security_account'


    in the specific database.

    EDIT: Replace 'security_account' with your domain users name in the database, e.g.: [domainname\groupname]

    Last edited by silco; 01-14-05 at 11:07.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •