nzsql -h `hostname` -u testuser -pw testuser
- GRANT/ REVOKE SELECT ON DATABASE ‘COMMON’
system(admin)=> grant list on common to testuser;
GRANT
common(admin)=> grant select on common to testuser;
common(admin)=> revoke all on common from testuser;
common(admin)=> \dpu testuser
- GRANT LIST/SELECT ON ALL TABLES IN A DATABASE ‘COMMON’
system(admin)=> \c common
common(admin)=> grant list on table to testuser;
common(admin)=> GRANT SELECT ON TABLE TO TESTUSER;
MORE -
grant all on table to <user>;
grant all on view to <user>;
grant all on procedure to <user>;
grant all on function to <user>;
grant all on sequence to <user>;
grant all on synonym to <user>;
Read More