Managing Oracle User Accounts, Schema and Privileges

Q

Where to find answers to frequently asked questions on Managing Oracle User Accounts, Schema and Privileges?

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle User Accounts, Schema and Privileges. Clear answers are provided with tutorial exercises on creating user accounts, granting privileges for session connections, granting privileges for creating tables and inserting rows.

User Account and Attributes in Oracle

User Account and Schema: One-to-One Relation in Oracle

User Role: Group of Privileges in Oracle

System Defined User Roles in Oracle

Built-in Internal User Accounts in Oracle

Use SYS Account to Connect to the Server in Oracle

Use Windows User to Connect to the Server in Oracle

Show All User Accounts in Oracle

Create a New User Account in Oracle

Change User Password in Oracle

Delete a User Account in Oracle

Privilege Needed to Connect to Oracle Server in Oracle

Grant CREATE SESSION Privilege in Oracle

Revoke CREATE SESSION Privilege in Oracle

Lock and Unlock a User Account in Oracle

Privilege to Create Tables in Oracle

Assign a Tablespace to a User in Oracle

Privilege to Create Views in Oracle

Privilege to Create Indexes in Oracle

Privilege to Query Tables in Another Schema in Oracle

Privilege to Insert Rows in Another Schema in Oracle

Privilege to Delete Rows in Another Schema in Oracle

Show Privileges of the Current User in Oracle

⇒ User Account and Attributes in Oracle

⇐ How Oracle Handles Dead Locks in Oracle

⇑⇑ Oracle Database Tutorials

2019-07-30, 3276🔥, 0💬