Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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