当前位置: 动力学知识库 > 问答 > 编程问答 >

sql - Restrict access to other schemas

问题描述:

I have created a user within Oracle Enterprise Manager, this user is the Admin of one schema. How do I restict access to other schemas in bulk, the database has about 50 schemas and the user shouldn't be able to view or interact with these other schemas.

Thanks

网友答案:

He is not able by default, unless access to other schemas' objects has been explicitly granted to PUBLIC. In this case, you have no easy options to restrict access to them.

网友答案:

You can use the following views to query for the privileges allowed for your user

FOR EXAMPLE: SELECT * FROM USER_TAB_PRIVS; --USER ALLOWED TABLE

USER_ROLE_PRIVS
USER_SYS_PRIVS
USER_TAB_PRIVS
USER_TAB_PRIVS_MADE
USER_TAB_PRIVS_RECD
ALL_COL_PRIVS
ALL_COL_PRIVS_MADE
ALL_COL_PRIVS_RECD
ALL_REPGROUP_PRIVILEGES
ALL_TAB_PRIVS
ALL_TAB_PRIVS_MADE
ALL_TAB_PRIVS_RECD
USER_AQ_AGENT_PRIVS
USER_COL_PRIVS
USER_COL_PRIVS_MADE
USER_COL_PRIVS_RECD
USER_REPGROUP_PRIVILEGES

分享给朋友:
您可能感兴趣的文章:
随机阅读: