Toad World® Forums

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

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.

This exists in the beta but not 12.10.

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