2uzhan.com
Advertisement
Now Place:2uzhan.com » With grant option

With grant option

DB2 @ July 9, 2014   Views:3

I am using SQLDBX as my tool for IBM DB2 LUW 9.5.

Each time I create new tables / modify existing tables I need to use the grant option to assign privileges to users.

I have a question though regarding the WITH GRANT OPTION command.

While my grant statement executes without any error a WITH GRANT doesn't.

For example WITH GRANT OPTION SELECT ON SCHEMA.TABLE TO USER; results in an error message stating Unexpected character /text.

Can someone please clarify?

Thanks

Tony

--------------Solutions-------------

grant select on table xx.yy to user uuu with grant option
means user uuu can forward the grant
IBM Knowledge Center

Tags:
© 2018 2uzhan.com Contact