OBJECTS

The OBJECTS view displays the name and system identifier for each schema object. This view is visible to SAS Federation Server System Users and Administrators. The table below lists the columns that are associated with this view:
Name
Type
Description
CATALOG_NAME
VARCHAR(256)
Specifies the catalog name.
SCHEMA_NAME
VARCHAR(256)
Specifies the schema name.
OBJECT_NAME
VARCHAR(256)
Specifies the object name.
OBJECT_TYPE
INTEGER
Object type:
1 – Table
2 – FedSQL View
3 – Cache
4 – Procedure/Function
5 – Any relation
6 – Not used
7 – Package
8 – DS2 Thread
FLAGS
INTEGER
Flags
1 - Definer's rights. For FedSQL views, the definer's rights bit indicates the view executes under the privileges of the view's schema owner rather than the invoker.
2 - Object was implicitly added as a result of a GRANT (as opposed to explicitly added through a user DDL). The object can be automatically removed if the grant is revoked.
Last updated: March 6, 2018