Connecting with Administrative Privileges: Example (33)

This example illustrates that a user is assigned another schema (SYS) when connecting
with the SYSDBA system privilege. Assume that the sample user oe has been granted
the SYSDBA system privilege and has issued the following statements:

CONNECT oe/oe

CREATE TABLE admin_test(name VARCHAR2(20));

Later, user oe issues these statements:

CONNECT oe/oe AS SYSDBA

SELECT * FROM admin_test;

User oe now receives the following error:
ORA-00942: table or view does not exist

Having connected as SYSDBA, user oe now references the SYS schema, but the table
was created in the oe schema.

以系統管理許可權登入例項

某使用者擁有sysdba許可權 , 當使用conn username/password as sysdba後 , 此時的方案物件為sys

[@more@]