Results 1 to 5 of 5

Thread: sso

  1. #1
    Join Date
    Dec 2003
    Posts
    14

    Unanswered: sso

    If a create a login with sso, does the new account has the same privileges (rights)then the SA aacount?

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    No.

    SA login has sa_role, sso_role, oper_role roles

  3. #3
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Originally posted by fadace
    No.

    SA login has sa_role, sso_role, oper_role roles
    Aren't the sa_role and the sso_role enough to do everything the sa-login can?
    I use an account with sa_role and sso_role, and I haven't come across something I wasn't allowed to do yet.

  4. #4
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Yes, sso + sa (who include oper) is ble to execute the main part of the statemetns (excepting some dbcc who request sybase_ts_role)

  5. #5
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4

    Thumbs up

    Originally posted by fadace
    Yes, sso + sa (who include oper) is ble to execute the main part of the statemetns (excepting some dbcc who request sybase_ts_role)
    Oh well, I guess I'll get some error or message telling me I need some other role then .
    Untill then it'll work fine.
    Thanks again. Wasn't expecting to learn something new today .

Posting Permissions

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