ORACLE新增，授权，修改，删除用户

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角色有哪些权限