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

Popular posts from this blog

javascript - gulp-nodemon - nodejs restart after file change - Error: listen EADDRINUSE events.js:85 -

Fatal Python error: Py_Initialize: unable to load the file system codec. ImportError: No module named 'encodings' -

javascript - oscilloscope of speaker input stops rendering after a few seconds -