Solved

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
4
462 Views
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))
etc
0
Comment
Question by:bmcdowell540
  • 2
4 Comments
 
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.
0
 
LVL 13

Accepted Solution

by:
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?
0
 
LVL 24

Expert Comment

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

Author Closing Comment

by:bmcdowell540
ID: 39729660
Thank you!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Generating a Format File in Sybase ASE BCP 1 1,171
Cannot create ODBC connection over the network 3 1,216
SyBase SQL DataTime Format 6 295
Executing multiple sybase statements in perl dbi 2 94
This tutorial shows how to create a greeting card by combining two image layers and a text layer on a PC using a free image editing app.
Knowing where your website is hosted is as important as the features you receive, the monthly fee, and the support you receive. Due diligence should be done when choosing your next hosting provider.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

821 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