How do I grant or revoke query access to a table?

Connect to the network database on a catalog server as a user with star$grant role granted to it. Use the grant_table() or revoke_table() functions to grant or revoke query access to a table respectively. You can also grant or revoke access to specific columns in a table using the grant_column() and revoke_column() functions.

See grant_table(), revoke_table(), grant_column(), revoke_column() and the Managing Tables section of the User Guide for further information.

Have more questions? Submit a request


Article is closed for comments.

Powered by Zendesk