Go Premium for a chance to win a PS4. Enter to Win

x
?
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
Medium Priority
?
482 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 1000 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 1000 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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

High user turnover can cause old/redundant user data to consume valuable space. UserResourceCleanup was developed to address this by automatically deleting user folders when the user account is deleted.
Your business may be under attack from a silent enemy that is hard to detect. It works stealthily in the shadows to access and exploit your critical business information, sensitive confidential data and intellectual property, for commercial gain. T…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

927 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