Grant on Protocols

Post date: Apr 29, 2013 11:38:19 AM

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