grant all privileges to user1 该user1的权限有多大
答案:2 mip版
解决时间 2021-02-07 22:22
- 提问者网友：負袮、叕哬妨
- 2021-02-07 16:44
grant all privileges to user1 该user1的权限有多大
最佳答案
- 二级知识专家网友：嶒經忲氾濫
- 2021-02-07 17:48
1。 改表法。 可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入mysql后，更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改成"%" Sql代码
全部回答
- 1楼网友：一个人,一辈子
- 2021-02-07 18:27
1、
select * from session_privs;
select * from user_sys_privs;
select * from user_tab_privs;
2、what privileges the resource contains:
select * from dba_sys_privs where grantee='resource';
3、roles & predefined roles
roles are named groups of related privileges that you grant to users or other roles.
predefined roles are defined automatically for oracle databases：
select * from dba_roles;
4、privileges
a privilege is a right to execute an sql statement or to access another user's object. in oracle, there are two types of privileges: system privileges and object privileges. a privileges can be assigned to a user or a role.
select * from system_privilege_map;
我要举报
如以上问答内容为低俗/色情/暴力/不良/侵权的信息，可以点下面链接进行举报，我们会做出相应处理，感谢你的支持！
点此我要举报以上问答信息
推荐资讯