How To List All User Accounts

Q

How To List All User Accounts? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges

✍: FYIcenter.com

A

User accounts can be accessed through a system view called ALL_USERS. A simple SELECT statement can be used to get a list of all user accounts. Try the following script:

>.\bin\sqlplus /nolog

SQL> connect SYSTEM/fyicenter
Connected.

SQL> SELECT * FROM ALL_USERS;

USERNAME                          USER_ID CREATED
------------------------------ ---------- ---------
FLOWS_020100                           35 07-FEB-06
FLOWS_FILES                            34 07-FEB-06
HR                                     33 07-FEB-06
MDSYS                                  32 07-FEB-06
ANONYMOUS                              28 07-FEB-06
XDB                                    27 07-FEB-06
CTXSYS                                 25 07-FEB-06
DBSNMP                                 23 07-FEB-06
TSMSYS                                 20 07-FEB-06
DIP                                    18 07-FEB-06
OUTLN                                  11 07-FEB-06
SYSTEM                                  5 07-FEB-06
SYS                                     0 07-FEB-06

2007-05-02, 5556👍, 0💬

How To List All User Accounts
How To List All User Accounts? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges User accounts can be accessed through a system view called ALL_USERS. A simple SELECT statement can be used to get a list of all user accounts. Try the following script: >.\bin\sqlplus /nolog SQL> ... 2007-05-02, 5557👍, 0💬

What Are the System Predefined User Roles
What Are the System Predefined User Roles? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges Oracle 10g XE comes with 3 predefined roles: CONNECT - Enables a user to connect to the database. Grant this role to any user or application that needs database access. RESOURCE - Enabl... 2007-05-02, 5263👍, 0💬

How To Change User Password
How To Change User Password? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want to change a user's password, you can log in as SYSTEM and use the ALTER USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connected. SQL>... 2007-05-02, 5178👍, 0💬

What Privilege Is Needed for a User to Connect to Oracle Server
What Privilege Is Needed for a User to Connect to Oracle Server? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges Oracle deny connection to users who has no CREATE SESSION privilege. Try the following tutorial exercise, you will find out how Oracle denies connection: >.\bin\sq... 2007-05-02, 5070👍, 0💬

How To Use Windows User to Connect to the Server
How To Use Windows User to Connect to the Server? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges During the installation process, 10g XE will create a special Windows user group called ORA_DBA, and put your Windows user into this group. Any Windows users in this group can be... 2007-05-02, 5014👍, 0💬

What Are Internal User Account
What Are Internal User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges An internal user account is a system predefined user account. Oracle 10g XE comes with a number of internal accounts: SYSTEM - This is the user account that you log in with to perform all administ... 2007-05-02, 4996👍, 0💬

How To Grant CREATE SESSION Privilege to a User
How To Grant CREATE SESSION Privilege to a User? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want give a user the CREATE SESSION privilege, you can use the GRANT command. The following tutorial exercise shows you how to grant DEV the privilege to connect to the ser... 2007-05-02, 4993👍, 0💬

What Is a User Role
What Is a User Role? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges A user role is a group of privileges. Privileges are assigned to users through user roles. You create new roles, grant privileges to the roles, and then grant roles to users. 2007-05-02, 4971👍, 0💬

How To Create a New User Account
How To Create a New User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want to create a new user account, you can log in as SYSTEM and use the CREATE USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connecte... 2007-05-02, 4970👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.