SYSSCHEMAS System Table
SYSSCHEMAS table describes the schemas within the current
database. It belongs to the
The following table shows the contents of the
SYS.SYSSCHEMAS system table.
||Unique identifier for the schema|
||The authorization identifier of the owner of the schema|
Access to the
SYS schema is restricted, for security purposes, to users for whom you Database Administrator has explicitly granted access. However, there is a corresponding
SYSVW.SYSSCHEMASVIEW system view, that allows you to access those parts of the table to which you have been granted access.
You can only query this system table if you have both
SELECT privilege on the table; your database administrator may have to
GRANT you these privileges.
If you don’t have access to this system table, you can use the view instead. Note that performance is better when using a table instead of its corresponding view. You can determine if you have access to this table by running the following command:
splice> DESCRIBE SYS.SYSSCHEMAS;
If you see the table description, you have access; if, instead, you see a message stating that “No schema exists with the name
SYS,” you don’t have access to the table; use the
SYSVW.SYSSCHEMASVIEW system view instead.
Here’s an example of using this table:
SELECT * FROM SYS.SYSSCHEMAS;