Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    17

    Unanswered: sa_role and sso_role

    Hi, looking at a table of sysloginroles, found several users with sa and sso roles; besides sa and other extra account , isn't it a security problem to find 8 or 7 users with this privileges assigned?

    (newbie on sybase)

  2. #2
    Join Date
    Mar 2009
    Location
    Sydney, Australia
    Posts
    258
    Well, yes and no. If the people are actually the people who should be granted sa_role and sso_role, no there is no problem, security is not breached. If the people who have such roles do not really have the authority to have them; did not get such roles by having the authorities grant it to them, then yes, you have a problem.

    It is good practice for real humans not to use the "sa" account; to have sa_role granted to their real login; and to disallow people from using non-human logins such as "sa" or "probe".
    Regards
    Derek Asirvadem (Formerly DerekA)
    Information Architect / Senior Sybase DBA
    Copyright 2009 Software Gems Pty Ltd

    I answer questions from the Original Poster only. If you have a genuine question, as the moderators have requested, start a new thread.

    http://www.softwaregems.com.au

Posting Permissions

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