|
EDA365欢迎您登录!
您需要 登录 才可以下载或查看,没有帐号?注册
x
本帖最后由 wan525jun 于 2023-4-20 17:37 编辑 3 ^. N: Y3 Z8 {' H& ~3 Y+ { u% H
; u k8 s3 C( i9 _( j0 p1 h! v0 S9 k+ r0 P: ?5 m
创建Database Link时的权限问题
- j/ C- o; t+ E( q5 \2 T
7 N8 O! {- t9 z. Q! ?; mcreate database link dl1 connect to scott identified by
" R. i" f. d6 j6 i9 b6 E _+ Y m
9 [ Q0 g) c* Z% o& ltiger using 'net1', Z/ g% H& [! \- e6 q
- \, Q& Q8 `/ ~$ ?" B U
ORA-01031: 权限不足2 Z& D- q8 s% J; X. y: X; l
7 V8 U1 o6 G5 b2 @* J- ySQL> select * from user_sys_privs;& P+ r; U4 v, C' v4 c% r
/ V- \. W9 z- K3 IUSERNAME PRIVILEGE 8 K# z# j f1 [! V: M, G) x. H
, ~* s$ F1 ^7 S* a! B1 y+ a* EADMIN_OPTION9 y+ H9 }& e; J' h# e
-------------------------
Q# l7 _2 s" z, A
% b6 C9 R% a Z# A6 M---------------------------------------- ------------
4 h+ |1 j- o( v8 G: YSCOTT CREATE DATABASE LINK
! @ g# b0 }; R% Y/ A: g, Y+ @& Q9 ?: T ]+ h! [' x
NO
5 v1 W0 s$ @7 \% e0 M& n" h, D) bSCOTT UNLIMITED TABLESPACE + ~3 v L( @5 k
, l% W" ]7 ?5 p% u4 | NO0 U! c3 b+ z8 W1 y! \5 _( L
/ k* V# v T+ w$ b. CSQL> create database link dl1 connect to scott identified
9 t& ]/ w( o" }! `+ I( ~. p7 q" X! D3 j% [0 d8 L
by tiger using 'net1';+ S) N+ a; n& m( [9 a9 q
' G7 l3 c( g: K' I
create database link dl1 connect to scott identified by
|$ h3 B- X& d" X: e0 I8 q( I! c+ `; Y' n2 k
tiger using 'net1'
. ?+ R. m( e4 N' a* ? r
: \, c& l* ~! L7 |ORA-01031: 权限不足 |
|