SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-205
Examples of GIVE Object
successful completion of this operation, all the existing opens of the target object are
invalidated. In case of VIEW ownership change, the existing opens on the underlying
tables are also invalidated.
Examples of GIVE Object

This example transfers the table ownership to “SQL.USER2”.
>>give table usertable to "sql.user2";
--- SQL operation complete.

This example transfers view ownership to “SQL.USER5”.
>>give view userview to "sql.user5";
--- SQL operation complete.

This example transfers procedure ownership to “SQL.USER3”.
>>give procedure userroutine to "sql.user3";
--- SQL operation complete.

This example transfers trigger ownership to “SQL.USER1”.
>>give trigger usertrigger to "sql.user1";
--- SQL operation complete.
GRANT Statement
Considerations for GRANT
Examples of GRANT
The GRANT statement grants access privileges for an SQL/MX table, view, or stored
procedure to specified users. See also GRANT EXECUTE Statement on page 2-211
GRANT {privilege [,privilege]... | ALL [PRIVILEGES]}
ON [TABLE] object
TO {grantee [,grantee ]...}
[WITH GRANT OPTION]
[BY authid-grantor]
grantee is:
authid | PUBLIC
privilege is:
SELECT
| DELETE
| INSERT
| UPDATE [(column [,column]...)]
| REFERENCES [(column [,column]...)]