查oracle系统中某用户已有的权限
select * from session_privs
1 CREATE SESSION
2 UNLIMITED TABLESPACE
3 CREATE TABLE
4 CREATE CLUSTER
5 CREATE VIEW
6 CREATE SEQUENCE
7 CREATE PROCEDURE
8 CREATE TRIGGER
9 CREATE ANY DIRECTORY
10 CREATE TYPE
11 CREATE OPERATOR
12 CREATE INDEXTYPE
13 DEBUG CONNECT SESSION
添加权限的方法
1. 进到sys用户下如
SQL> conn sys/123456@10.10.1.111/orcl as sysdba
2. 给新用户conquer加权限如
SQL> grant create session to conquer;
网友评论