learn-oracle




Database Administrative Accounts


Database Administrative Accounts

When Oracle DBA create an Oracle Database, the user SYS is automatically created and granted the DBA role.
Administering Roles

System privileges, object privileges, and roles provide a basic level of database security. They are designed to control user access to data and to limit SQL statements that users can execute.Read on to read more about Oracle Roles .
 
Administering Profiles

A user profile establishes the password management policy for a user and defines and limits the userís access to certain database resources Oracle DBA specify that the user be assigned the Oracle-supplied default profile.
Administering Database Users

In this section, Oracle DBA create a user named MYUSER, set the password, and assign MYUSER to the USERS tablespace.
 
Editing Users

Oracle DBA can change the attributes of users by clicking Edit on the Users page and selecting the properties page with the attributes that Oracle DBA want to change.
Dropping Users

Enterprise Manager enables Oracle DBA to drop users. However, Oracle DBA must excerise caution when doing so, since dropping user will drop all schema objects owned by the user including tables and indexes.

More Tutorials on Oracle dba ...


Liked it ? Want to share it ? Social Bookmarking

Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information


Source : Website | Oracle DBA

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info





   Forum
Oracle Forum   
Google

Oracle DBA Tutorial
Introduction
Installation
Oracle Enterprise Manager
Configuring client/server network
Database Instance
Database Storage Structures
DBA Accounts
Managing Oracle Objects
Backup & Recovery Concepts
Database Monitoring

SQL Statement Tuning
Backup and Recovery Concepts
Oracle 11g New Features
Oracle E Suite & Others
Oracle Data Guard
Oracle DBA FAQ