Results 1 to 2 of 2

Thread: SQL 6.5 Security

  1. #1
    darlene Guest

    SQL 6.5 Security

    I need to give someone permission to create logins and users to a SQL 6.5 database. Is the sa login the only way to create sql logins and db users? How or what do I give to an individual user to grant them this permission. I am familiar with sql 7.0 which has defined server and db roles but what does sql 6.5 give you?

    Thanks
    Darlene

  2. #2
    Prajay Guest

    SQL 6.5 Security (reply)

    Hi

    The only way I can think of getting round this is to give execute permissions to the user on sp_adduser and sp_addlogin in the master db.

    Cheers
    Praj


    ------------
    darlene at 9/13/00 3:36:28 PM

    I need to give someone permission to create logins and users to a SQL 6.5 database. Is the sa login the only way to create sql logins and db users? How or what do I give to an individual user to grant them this permission. I am familiar with sql 7.0 which has defined server and db roles but what does sql 6.5 give you?

    Thanks
    Darlene

Posting Permissions

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