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@]

ITPub博客

Connecting with Administrative Privileges: Example (33)

最新文章