oracle用户权限
sys:数据库超级用户,必须以sysdba的身份进行登录的
1.创建新用户
create user user_name identified by password default tablespace tablespace_name;
####创建只读用户
SQL> create user zhangsan identified by 123456;
User created.
2.权限授权
1)给普通用户授权
SQL> grant connect,resource to zhangsan;
Grant succeeded.
2)授权系统权限
##创建连接会话权限
grant create session to zhangsan;
##创建同义词权限(如果不适用同义词则不需要授权)
grant create synonym to zhangsan;
3)给管理员用户授权
SQL> grant connect,resource,DBA to zhangsan;
Grant succeeded.
3.回收权限
SQL> revoke DBA from zhangsan;
Revoke succeeded.
4.用户禁止删除
##锁定用户
alter user zhangsan account lock;
##解锁用户
alter user zhangsan account unlock;
##删除用户
drop user zhangsan;
##删除同义词
drop [public] synonym 公共表说明;
5.查看数据库用户/角色
##查看用户
SQL> select * from all_users;
##查看角色
SQL> select * from dba_roles;
##查看系统权限
select * from dba_sys_privs;
select * from user_sys_privs;
##查看对象权限
select * from dba_tab_privs;
select * from all_users;
select * from user_tab_privs;
##查看当前用户
show user
##查看当前数据库
show parameter instance_name;
show parameter service;
show parameter db;
6.修改用户密码
##修改系统账号密码
alter user user_name identified by user_password;