skip to main | skip to sidebar

Oracle Tips-n-Tricks

A helpful list of useful Oracle SQL functions.

Tuesday, April 15, 2008

List existing user accounts within an Oracle SID

Execute the following SQL as SYS or SYSTEM
select distinct username from dba_users order by username desc;
Posted by scspieker at 10:13 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2008 (13)
    • ▼  April (13)
      • Run SQL commands at login with SQL*Plus
      • Enabling SQL*Plus Help Utility
      • Using the default editor (Notepad or VI) for SQL C...
      • What are the basic SQL*Plus commands?
      • Shrink Oracle LOB columns
      • Display all TABLE Owning users with an Oracle SID
      • Find the Characterset Encoding for an Oracle SID
      • Display Oracle SID name using SQL
      • List existing user accounts within an Oracle SID
      • Find Oracle Server Version information using SQL
      • Unlock an Oracle user account
      • Sample Oracle Create User SQL Script
      • Oracle Create Tablespace Example