DBE_PLDEVELOPER.gs_source
Records information about PL/SQL objects (stored procedures, functions, packages, and package bodies), as described in Table 1.

- The gs_source table records only user-defined original object statements. Even if a user uses ALTER to change the created schema or name, the information in the gs_source table does not change. If the user changes the schema or name of an object, after the user deletes the object, the object is deleted from the gs_source table.
- The owner in the gs_source table is the user who creates the table, not the user specified when the user creates the stored procedure or package.
- After the GUC parameter behavior_compat_options="skip_insert_gs_source" is set, information about PL/SQL objects (stored procedures, functions, packages, and package bodies) is not recorded in the gs_source table.
- The permissions of gs_source are the same as those of system catalogs in pg_catalog. System administrators and common users cannot perform DROP, ALTER, DELETE, UPDATE, and INSERT operations, but can perform the SELECT operation. The GUC parameter allow_system_table_mods is used to control the permissions of gs_source, and the default value is off. After modifying this parameter, you need to restart the database for the modification to take effect.
- By default, row-level security is not configured for the gs_source table in the database. If you need to use the database isolation feature, use the following statement to add row-level security:
ALTER TABLE dbe_pldeveloper.gs_source ENABLE ROW LEVEL SECURITY; CREATE ROW LEVEL SECURITY POLICY all_data_rls ON dbe_pldeveloper.gs_source USING(owner = (SELECT oid FROM gs_roles WHERE rolname=current_user));
Name |
Type |
Description |
id |
oid |
Object ID. |
owner |
bigint |
ID of the user who creates the object. |
nspid |
oid |
Schema ID of an object. |
name |
name |
Object name. |
type |
text |
Object type (procedure/function/package/package body). |
status |
Boolean |
Determines whether the creation is successful. |
src |
text |
Original statement for creating an object. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot