sys@cdb$root:orclcdb> grant sysdba to scott;
grant sysdba to scott
*
ERROR at line 1:
ORA-65175: cannot grant SYSDBA privilege locally in the root
sys@cdb$root:orclcdb> ALTER SESSION SET CONTAINER=ORCLPDB1;
Session altered.
sys@cdb$root:orclcdb> show user;
USER is "SYS"
sys@cdb$root:orclcdb> grant sysdba to scott;
Grant succeeded.
sys@cdb$root:orclcdb>
[oracle@MaxwellDBA admin]$ sqlplus sys/sys as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 28 14:21:57 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
sys@cdb$root:orclcdb> @/opt/oracle/product/19c/dbhome_1/rdbms/admin/utlxplan.sql
Table created.
sys@cdb$root:orclcdb> CREATE PUBLIC SYNONYM PLAN_TABLE FOR PLAN_TABLE;
CREATE PUBLIC SYNONYM PLAN_TABLE FOR PLAN_TABLE
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
sys@cdb$root:orclcdb> GRANT ALL ON PLAN_TABLE TO PUBLIC
2 ;
Grant succeeded.
sys@cdb$root:orclcdb> show user;
USER is "SYS"
sys@cdb$root:orclcdb> @/opt/oracle/product/19c/dbhome_1/sqlplus/admin/plustrce.sql
sys@cdb$root:orclcdb>
sys@cdb$root:orclcdb> drop role plustrace;
drop role plustrace
*
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist
sys@cdb$root:orclcdb> create role plustrace;
create role plustrace
*
ERROR at line 1:
ORA-65096: invalid common user or role name
sys@cdb$root:orclcdb>
sys@cdb$root:orclcdb> grant select on v_$sesstat to plustrace;
grant select on v_$sesstat to plustrace
*
ERROR at line 1:
ORA-01917: user or role 'PLUSTRACE' does not exist
sys@cdb$root:orclcdb> grant select on v_$statname to plustrace;
grant select on v_$statname to plustrace
*
ERROR at line 1:
ORA-01917: user or role 'PLUSTRACE' does not exist
sys@cdb$root:orclcdb> grant select on v_$mystat to plustrace;
grant select on v_$mystat to plustrace
*
ERROR at line 1:
ORA-01917: user or role 'PLUSTRACE' does not exist
sys@cdb$root:orclcdb> grant plustrace to dba with admin option;
grant plustrace to dba with admin option
*
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist
sys@cdb$root:orclcdb>
sys@cdb$root:orclcdb> ALTER SESSION SET CONTAINER=ORCLPDB1;
Session altered.
sys@cdb$root:orclcdb> show user;
USER is "SYS"
sys@cdb$root:orclcdb> @/opt/oracle/product/19c/dbhome_1/sqlplus/admin/plustrce.sql
sys@cdb$root:orclcdb> --
sys@cdb$root:orclcdb> -- Copyright (c) Oracle Corporation 1995, 2002. All Rights Reserved.
sys@cdb$root:orclcdb> --
sys@cdb$root:orclcdb> -- NAME
sys@cdb$root:orclcdb> -- plustrce.sql
sys@cdb$root:orclcdb> --
sys@cdb$root:orclcdb> -- DESCRIPTION
sys@cdb$root:orclcdb> -- Creates a role with access to Dynamic Performance Tables
sys@cdb$root:orclcdb> -- for the SQL*Plus SET AUTOTRACE ... STATISTICS command.
sys@cdb$root:orclcdb> -- After this script has been run, each user requiring access to
sys@cdb$root:orclcdb> -- the AUTOTRACE feature should be granted the PLUSTRACE role by
sys@cdb$root:orclcdb> -- the DBA.
sys@cdb$root:orclcdb> --
sys@cdb$root:orclcdb> -- USAGE
sys@cdb$root:orclcdb> -- sqlplus "sys/knl_test7 as sysdba" @plustrce
sys@cdb$root:orclcdb> --
sys@cdb$root:orclcdb> -- Catalog.sql must have been run before this file is run.
sys@cdb$root:orclcdb> -- This file must be run while connected to a DBA schema.
sys@cdb$root:orclcdb>
sys@cdb$root:orclcdb> set echo on
sys@cdb$root:orclcdb>
sys@cdb$root:orclcdb> drop role plustrace;
drop role plustrace
*
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist
sys@cdb$root:orclcdb> create role plustrace;
Role created.
sys@cdb$root:orclcdb>
sys@cdb$root:orclcdb> grant select on v_$sesstat to plustrace;
Grant succeeded.
sys@cdb$root:orclcdb> grant select on v_$statname to plustrace;
Grant succeeded.
sys@cdb$root:orclcdb> grant select on v_$mystat to plustrace;
Grant succeeded.
sys@cdb$root:orclcdb> grant plustrace to dba with admin option;
Grant succeeded.
sys@cdb$root:orclcdb>
sys@cdb$root:orclcdb> set echo off
sys@cdb$root:orclcdb> grant plustrace to public
2 ;
Grant succeeded.
sys@cdb$root:orclcdb>