| Subject | Can roles grant rights given 'WITH GRANT OPTION'? |
|---|---|
| Author | mydejamail |
| Post date | 2002-09-09T23:40:56Z |
After granting table rights to a role 'WITH GRANT OPTION' a user
added
to the role cannot grant rights that are supposed to go with the role,
even though the user logged on with the role.
The following error appears:
SC ERROR CODE:335544351
ISC ERROR MESSAGE:
unsuccessful metadata update
no S privilege with grant option on table/view AFCREDIT
Statement: GRANT SELECT ON AFCREDIT TO MIKE
Is this a known bug or feature?
added
to the role cannot grant rights that are supposed to go with the role,
even though the user logged on with the role.
The following error appears:
SC ERROR CODE:335544351
ISC ERROR MESSAGE:
unsuccessful metadata update
no S privilege with grant option on table/view AFCREDIT
Statement: GRANT SELECT ON AFCREDIT TO MIKE
Is this a known bug or feature?