Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 167
  • Last Modified:

users

I want to see list of users other than sys and system in a database
0
thomasliju
Asked:
thomasliju
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
select username from dba_users where username not in ('SYS','SYSTEM');

You know, a quick scan of the docs will show you all the system views like DBA_OBJECTS, DBA_USERS, DBA_TABLES, etc...
0
 
thomaslijuAuthor Commented:
Slightvv  

till what time you are available..
after your working hours what ever query I am asking can you escalate to other experts.
0
 
slightwv (䄆 Netminder) Commented:
Experts here monitor the Zones they frequent.

If I don't get to a question, other Experts will pick it up.
0
 
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now