Table Level Security
Table level security defines who can access a table with set of allowed permissions. A table cannot be accessed if table level security is not setup.
Table level security is associated with the following information.
-
Schema Name
-
Table Name
-
Security Group - Provides who can access the table
-
Access Level - Provides permissions
Table level securities are set up for all tables when default security is setup using the end point. Every table is setup to be accessed by users in all security groups with default permissions.
Example
Table - DdsAdminGroup, DdsAdminAccessLevel
Table - DdsOperatorGroup, DdsOperatorAccessLevel
Table - DdsMonitorGroup, DdsMonitorAccessLevel