Grant on Protocols

posted Apr 29, 2013, 4:38 AM by Sachchida Ojha
After creating a custom protocol, specify CREATE TRUSTED PROTOCOL to be able to allowing any user besides the owner to access it. If the protocol is not trusted, you
cannot give any other user permission to use it to read or write data. After a TRUSTED protocol is created, you can specify which other users can access it with the GRANT
command.

1. To allow a user to create a readable external table with a trusted protocol GRANT SELECT ON PROTOCOL protocolname TO username
2. To allow a user to create a writable external table with a trusted protocol GRANT INSERT ON PROTOCOL protocolname TO username
3. To allow a user to create both readable and writable external table with a trusted protocol GRANT ALL ON PROTOCOL protocolname TO username
Comments