|
EDA365欢迎您登录!
您需要 登录 才可以下载或查看,没有帐号?注册
x
本帖最后由 wan525jun 于 2023-4-20 17:37 编辑 5 ]6 `' y4 l: z5 C7 f
# q* ^9 ~* T* F' y& z# z! _5 A3 X) M/ T3 X$ D
创建Database Link时的权限问题" ?% K! ]' B% G4 H
5 _* h- g" E# A
create database link dl1 connect to scott identified by
9 u' t) h' T- N5 z9 {% ]" x) S( ~, c9 }7 S" G( R
tiger using 'net1'
9 V9 _) E! q$ s' H1 [3 n0 |, g% s3 F, \1 ~! ]3 ^8 u* C
ORA-01031: 权限不足; z% t% \; Y1 P- r
& ]; z! z5 C2 l+ u, ^
SQL> select * from user_sys_privs;
0 K: j% g: r; A4 e: o( z& e' W- I9 }2 i w4 I
USERNAME PRIVILEGE
& }2 v1 `# V. e+ q1 u) u: @& Q1 T% d2 c0 q- @) H/ Z
ADMIN_OPTION# ^* @. G# ]. \: @6 T
------------------------- # O3 { ^; x! S: v$ c; t
4 h+ C, z: M2 p! d0 a
---------------------------------------- ------------' N3 C( `. \3 @! ~% g1 y
SCOTT CREATE DATABASE LINK 3 Z$ ?; p. u, L6 u- V4 l n
8 }3 V5 }5 G- p [, N5 Q; w' ]NO2 r1 r! a" h- L+ o. ]: V. J
SCOTT UNLIMITED TABLESPACE
' @9 I: Y0 r2 e. ~* B$ x
) y# n' c% _8 g ] NO& x' }4 a, g0 Y, ]$ r8 h3 n
/ ~ u6 b4 K" g1 f7 ISQL> create database link dl1 connect to scott identified 4 B2 J- |& _. t+ _& ~+ y' F
/ O1 q+ n9 x: {( ^' M$ T
by tiger using 'net1';
9 T; o6 {! i' Q3 L
) r# g0 O# `: n# ?0 H/ ^5 I4 ^create database link dl1 connect to scott identified by
5 f0 j0 N2 P1 w8 g
5 J0 K8 c) E2 e5 R8 D) a) ltiger using 'net1'# O6 v% `2 W3 j0 F; o2 g
$ @% W# t, Z' t5 n
ORA-01031: 权限不足 |
|