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?

Posted on 2013-12-16
Last Modified: 2013-12-19
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))
Question by:bmcdowell540
  • 2
LVL 24

Assisted Solution

by:Joe Woodhouse
Joe Woodhouse earned 250 total points
ID: 39723561
Assuming this is Sybase ASE or Sybase IQ... yes, you can lock the group so it can't be directly used as a login.
LVL 13

Accepted Solution

alpmoon earned 250 total points
ID: 39724312
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?
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 39726297
Oops, typo, yes ASA.

Author Closing Comment

ID: 39729660
Thank you!

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sybase ASE BCP In With Table with No Identity Column 1 1,180
Time optimization for insert/update in ultralite. 3 126
sql anywhere query 5 139
Default Read Only User Sybase DB 1 105
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now