http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [64]
02.File Book
File 자료실 [93]
Site Link [15]
개인폴더 [184]
03.Field Book
Altibase [15]
Tibero [22]
MS-SQL [17]
MySQL [33]
DB2 [75]
ORACLE [2493]
PostgreSQL [73]
기타정보 [136]
운영체제 [544]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: ORACLE

 회원가입

dba role create view ORA-01031: insufficient privileges
최길호 [LIST]   2020-06-28 00:20:30, 조회 : 62


dba role을 가지고 select는 되는데
view 만들때 ORA-01031 에러 난다.

select는 object가 아니라서 dba role을 거쳐서 에러가 없지만.
create view ... 하려면 소유자 또는 DBA가 grant ... 해서 권한을 줘야 만들 수 있다.

SYS@SQL> grant dba,create view to b;

Grant succeeded.

Elapsed: 00:00:00.04
B@SQL> select * from a.at;

         A          B          C
---------- ---------- ----------
         1          1          1

Elapsed: 00:00:00.00
B@SQL> create view system.bv as select * from a.at;

View created. <<== system.bv [ DBA B 계정 system.bv ]

Elapsed: 00:00:00.08
B@SQL> create view bv as select a from a.at where b=1;
create view bv as select a from a.at where b=1
                                  *
ERROR at line 1:
ORA-01031: insufficient privileges <<== b.bv [ DBA B 계정 b.bv ]
B@SQL> set role dba;

Role set.

B@SQL> create view bv as select a from a.at where b=1;
create view bv as select a from a.at where b=1
                                  *
ERROR at line 1:

SYS@SQL> create view bv as select a from a.at where b=1;

View created. <<== sys 계정 sys.bv

Elapsed: 00:00:00.05
SYS@SQL> create view b.bv as select a from a.at where b=1;
create view b.bv as select a from a.at where b=1
                                    *
ERROR at line 1:
ORA-01031: insufficient privileges <<== b.bv [ sys 계정 ]


  LIST

제목 작성자 작성일 조회
Admin  진행중.    최길호 2008/11/26 105
Admin  [ 필요 하신게 있으시면 Login 하시고 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]    최길호 2006/07/14 122
Troubleshoot  ORA-02291: integrity constraint / ORA-02292: integrity constraint / ORA-02449: unique/primary keys / ORA-02298: cannot validate [ 제약조건 ]    최길호 2020/07/14 13
Admin  데이터 유지 ASM 재설치 test [ asmcmd md_backup ]    최길호 2020/07/13 3
Troubleshoot  PLS-00103: Encountered the symbol / PLS-00201: identifier    최길호 2020/07/08 10
Troubleshoot  ADVM Driver Not installed / ORA-15032 ORA-15489 delete waiting for last close    최길호 2020/07/08 30
Troubleshoot  dba_scheduler_running_jobs session_id is null    최길호 2020/07/05 17
Script  linux config, dbca, create tablespace, expdp, rman backup script    최길호 2020/07/02 29
Troubleshoot  PLS-00302: component 'table' must be declared    최길호 2020/07/02 32
Admin  dba role create view ORA-01031: insufficient privileges    최길호 2020/06/28 62
Admin  v$sql v$db_object_cache v$object_dependency dba_dependencies [ grant 정보, SYNONYM , object 연관성 확인 , SQL query 연관성 조사, grant 권한 연결 참조 ]    최길호 2020/06/26 2669
Admin  dbms_scheduler 사용 [ LOG 1년6개월 보관 ] exec DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE('log_history','550');    최길호 2020/06/18 137
Troubleshoot  ORA-01157: cannot identify/lock data file 77 - see DBWR trace file 조치 예    최길호 2020/06/15 108
Troubleshoot  ORA-04063: view SYS.DBA_HIST_SQL_PLAN has errors    최길호 2020/05/28 121
Backup and Recovery  rman cdb pdb backup / restore / recover    최길호 2020/05/28 126
Backup and Recovery  impdp system/<pwd> ... remap_table=EMP_INFO:EMP_INFO_0525 tables=scott.emp_info    최길호 2020/05/26 147

    목록보기   다음페이지 1 [2][3][4][5][6][7][8][9][10]..[125]   [다음 10개]
       

Copyright 1999-2020 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
2019/05/02
pkg 확인 SELECT * FROM AL...
by 최길호
2018/05/18
Name Type ...
by 최길호
2018/01/07
ORA-00020: maximum number of...
by 최길호
최근 게시물
07/16
[운영체제]
docker search / rename / commi....
by 최길호
07/15
[운영체제]
docker login / oracle 12.2.
by 최길호
07/14
[ORACLE]
ORA-02291: integrity constrain....
by 최길호