Is there a way to disable or lock the group “account” so the role/privilege cannot be used or does not get used until it is needed for maintenance as a security requirement?

Is there a way to disable or lock the group “account” so the role/privilege cannot be used or does not get used until it is needed for maintenance as a security requirement?

In the Users and groups, one can give set passwords for these” groups” not just the “users” so they must be technically accounts that can be used to elevate privileges.

I see owners to tables for example:

DBA (this is the only one that is an actual “user”)
SYS (this shows it is a group(role))
Dbo (this shows it is a group(role))
Rs_systablgroup (this shows it is a group(role))
etc
LVL 1
bmcdowell540Asked:
Who is Participating?
 
alpmoonConnect With a Mentor Commented:
Joe, I guess you meant Sybase ASA rather than ASE. ASA is also default for Sybase IQ system database. Sybase ASE doesn't allow using a group to connect to an ASE server with a password.

Have you tried to create a LOGIN POLICY to lock a user and apply it to a group by ALTER USER?
0
 
Joe WoodhouseConnect With a Mentor Principal ConsultantCommented:
Assuming this is Sybase ASE or Sybase IQ... yes, you can lock the group so it can't be directly used as a login.
0
 
Joe WoodhousePrincipal ConsultantCommented:
Oops, typo, yes ASA.
0
 
bmcdowell540Author Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.