Monday, July 5, 2010

Connection with Administrator Privileges.

Database startup and shutdown are powerful administrative options and are restricted to users who connect to Oracle with administrator privileges. Depending on the operating system. one of the following conditions establishes administrator privileges for a user.

1) The user's operating system privilleges allow him or her to using administrating privileges.

2)The user is granted the SYSDBA or SYSOPER privileges and the database uses password files to authenticate database administrators.

When you connect with SYSDBA privilleges, you are in the schema owned by SYS.

When you connect as SYSOPER , You are in the PUBLUC schema.SYSOPER privileges are a subset of SYSDBA privileges.

No comments:

Post a Comment