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
467 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

After-hours service is a fact of life for most MSPs. While not the most pleasant aspect of the job, there are ways to make after-hours servicing a more profitable and organized enterprise.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

735 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