zz$schema

From zzat
Jump to: navigation, search

zz$schema stores information about the zztat users and their purpose, as well as what features are enabled in which schema.

It has the following columns:

Column Name Data Type Description
zz$db number Database DBID from zz$db.
username varchar2 User name of the zztat user.
user_type varchar2 REPOSITORY or APPLICATION.
alter_session varchar2 'Y' if the schema on this database has been configured to have the ALTER SESSION system privilege. 'N' otherwise.
alter_system varchar2 'Y' if the schema on this database has been configured to have the ALTER SYSTEM system privilege. 'N' otherwise.
dbms_system varchar2 'Y' if the schema on this database has been configured to use dbms_system. 'N' otherwise.
send_emails varchar2 'Y' if the schema on this database has been configured to send emails. 'N' otherwise.
create_acls varchar2 'Y' if the schema on this database has been configured to create Oracle network ACLs for sending emails. 'N' otherwise.
comments varchar2 Comment field describing the user.