grant all privileges to user1 该user1的权限有多大

grant all privileges to user1 该user1的权限有多大

1。 改表法。 可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入mysql后，更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改成"%" Sql代码

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;