How To REVOKE permissions

M

meringros

New Member
Hello,

I see records in the _Systabauth table that I would like to remove.
In all cases both _grantor and _grantee are the same (and they are not sysprogress), _TblOwner is PUB.

"REVOKE ALL ON Pub.tablename FROM username;" - executes but doesn't affect any rows.

Any suggestions?

Question #2: what is the difference between permission = "y" vs "g" in permission columns such as _Sel?


Thanks.
 
>Question #2

y -- means yes, permission is granted
g -- means yes, permission is granted with grant option. That means that permission is not only granted to the user, but that user could in turn grant it to others. In other words "g" is more advanced permission then "y".
 
You must log in or register to reply here.
Back
Top