To grant permissions on a table column -
GRANT <permission> ON <schema>.<tablename>(<columnname>) TO <GRANTEE>
<permission> = SELECT | UPDATE | REFERENCES
To deny permissions on a table column -
DENY <permission> ON <schema>.<tablename>(<columnname>) TO <GRANTEE>
No comments:
Post a Comment