The solidDB^® system tables store solidDB^® server information, including user information. Your ability to access specific system tables depends on your user’s role and access rights. For example, DBAs can view all information about all stored procedures, including the procedure definition text (that is, the CREATE PROCEDURE statement). Normal users can see the stored procedures, including the procedure definition text, for procedures that they have created. Normal users who have execute access on a stored procedure, but who did not create that stored procedure, may look at some information about that stored procedure but may not see the procedure definition text. For a list of system tables, see Database system tables and system views.

The table below provides the viewing access and/or object granting privileges for specific system tables and their data by user role and user access rights.

Note that a “User with access rights” in this table refers to a normal user who has any one of the following rights: INSERT, UPDATE, DELETE, or SELECT access.*