|
|
EDA365欢迎您登录！
您需要 登录 才可以下载或查看，没有帐号？注册
x
本帖最后由 wan525jun 于 2023-4-20 17:37 编辑
( e% v% k- w6 b' ~. S" H2 `- \( S
, E/ I& c, r2 H) j3 A8 e4 I
% g. A3 H0 h5 l* f' S创建Database Link时的权限问题
; P! M6 {$ K* ?+ w2 E- h' H
, w; [0 ~ X: ecreate database link dl1 connect to scott identified by
6 i6 j W2 N# _* {( n
4 r' e0 q, ]5 n" E# G( }' Ltiger using 'net1'
* e. U, k4 f9 K) ?" q+ L: T% I" I* P/ L# r: }; s
ORA-01031: 权限不足& f' E" |- ?6 O6 C3 o4 a6 x& f4 r, y
& k) q: C- G: X# T
SQL> select * from user_sys_privs;9 R5 Q$ \' L* N( X
, ~, Z7 A5 Y) }2 Q$ {# t( ]
USERNAME PRIVILEGE . V3 H" K! {' ^ E& C$ E
3 q% U1 g4 s r4 c: z4 U4 iADMIN_OPTION
0 N0 C. |1 s1 b9 r8 T) t-------------------------
* y& e# v7 ?: M) r3 v, B8 { D
- l8 ~, n- E( W- | l$ Y, ~---------------------------------------- ------------
7 {, R4 B# r" S/ V8 ]& N7 CSCOTT CREATE DATABASE LINK $ k. F! G3 q' B3 J6 m
" t0 _3 n4 H$ ?1 F: y; R. C) n4 ~, F
NO3 _& K3 F0 V1 V8 R d
SCOTT UNLIMITED TABLESPACE
/ ?' I5 c9 l# y9 w% n, w- \
6 s/ T+ J& K) Q) k NO
% x1 d) o. n D5 e, ?9 N- Y6 b7 t H, B$ _1 L. V$ P) K& b
SQL> create database link dl1 connect to scott identified
2 S0 k# {9 M4 y. \/ J! W3 y: W5 s& F0 E! o V, A7 W* J+ p# n
by tiger using 'net1';
$ d. `' O9 r4 Q# a4 @! @5 |* ^+ K/ O# H, y1 j
create database link dl1 connect to scott identified by ) F- [7 ?8 }' s+ v( q5 k: V5 q
4 ]; C7 Q( x6 T5 x, [tiger using 'net1'
8 a2 w! |4 `& L5 L+ J. q2 G4 F
0 P- \: ^+ U/ r* I. uORA-01031: 权限不足 |
|
/1 
发表于 2023-4-20 17:03
收藏
淘帖
支持！
反对！