ORACLE新增,授权,修改,删除用户
select username from dba_users;–查看数据库中所有用户的名称;
create user mike identified by 3713;–新建用户
alter user mike identified by 3714;–改密用户
drop user mike;–删除用户
drop user mike cascade;–同时删除与mike相关的表;
//授权
grant connect to mike;–登录授权;
grant select on emp to mike;–scott用户为mike赋予表emp的select权限;
grant select on scott.emp to mike;–sys用户为mike赋予表emp的select权限;
grant select,insert,delete,update on scott.emp to mike;–授予增删改查权限
grant connect,resource to mike;
resource的权限包括:http://blog.csdn.net/henulwj/article/details/8032677
//权限回收
revoke select on emp from mike;–scott用户回收mike对emp表的select权限;
revoke select on scott.emp from mike;–sys用户回收mike对emp表的select权限;
//查看权限与角色
select * from session_privs;–查看当前用户本身具有的权限
select * from user_role_privs;–查看当前用户本身具有的角色
select * from user_role_privs where GRANTED_ROLE=’CONNECT’;–查看connect角色有哪些权限
ORACLE新增,授权,修改,删除用户
select username from dba_users;--查看数据库中所有用户的名称;
create user mike identified by 3713;--新建用户
alter user mike identified by 3714;--改密用户
drop user mike;--删除用户
drop user mike cascade;--同时删除与mike相关的表;
//授权
grant connect to mike;--登录授权;
grant select on emp to mike;--scott用户为mike赋予表emp的select权限;
grant select on scott.emp to mike;--sys用户为mike赋予表emp的select权限;
grant select,insert,delete,update on scott.emp to mike;--授予增删改查权限
grant connect,resource to mike;
resource的权限包括:http://blog.csdn.net/henulwj/article/details/8032677
//权限回收
revoke select on emp from mike;--scott用户回收mike对emp表的select权限;
revoke select on scott.emp from mike;--sys用户回收mike对emp表的select权限;
//查看权限与角色
select * from session_privs;--查看当前用户本身具有的权限
select * from user_role_privs;--查看当前用户本身具有的角色
select * from user_role_privs where GRANTED_ROLE='CONNECT';--查看connect角色有哪些权限