Our teacher let us create some user U100, U101, U102, U103, U104 and give them some authority, after he has given us some code to check permissions, the code is as follows:
Confirm these privileges by selecting the table privileges for each user from the sys. Dba_tab_privs data dictionary view. Use the following format and display your results:

Col owner format of a20
Col table_name format a15
A10 col privilege the format
A10 col grantee the format

SELECT the owner, the privilege, table_name, grantee
The FROM sys. Dba_tab_privs
U1 WHERE grantee like '%'
The ORDER BY the grantee, table_name, privilege;

But I don't know for what reason when creating the user cannot create the same user, to be before the user name and # # to create properly, so I create a user name is c # # U100 U101 c # #, # # U102 U103 c # #, # # U104, run after and then complete the authorization of privileges to the teacher's command line shows "not selected row", I have to change the WHERE clause WHERE grantee like 'c # # U1 %' but still the same result - "not selected row,"

Excuse me, can help me to solve the problem? Is in front of the format of problem,,,

CodePudding user response:

You need in PDB operation, rather than on the outside of CDB directly create a c # # in the form of a user, the user, you try to query cdb_tab_privs view and have a look