Is there a way to get user's CONTAINER_DATA attributes?

Toad for Oracle
1

CREATE USER c##testuser

IDENTIFIED BY pa55w0rd

DEFAULT TABLESPACE users

TEMPORARY TABLESPACE temp

PROFILE c##aep_process_profile

ACCOUNT UNLOCK;

GRANT CREATE SESSION TO c##testuser;

GRANT SELECT ON sys.v_$pdbs TO c##testuser;

alter user c##testuser set container_data=all for sys.v_$pdbs container=current;

select * from dba_container_data where username = ‘C##TESTUSER’;

I was originally looking for this information in a user’s Script, but now that I think about it some more it might also be nice to see it somewhere on the Grants tab of schema browser or describe windows.

2

This exists in the beta but not 12.10.

In SB-Users, there is a RHS tab called “Container Data Restrictions”