sql - All users can access DBC tables by default -
i created test dbuser basic rights , log in in sql assistant, can select on every tables in dbc database. checked other users, , can. tried :
revoke select on "dbc" my_user;
but didn't work. know how can modify access rights on dbc ?
those access rights not granted on user lever, public. if done on dbc
(= database level) should revoked, because there security tables dbc.dbase
holds encrypted passwords.
revoke select on "dbc" public;
end users should have access on dbc.views.
Comments
Post a Comment