|
|
EDA365欢迎您登录！
您需要 登录 才可以下载或查看，没有帐号？注册
x
本帖最后由 wan525jun 于 2023-4-20 17:37 编辑
0 `. Q. D2 u5 ~
8 L- j4 g: w+ B. R7 E. n8 g/ y# E$ E9 m! R
创建Database Link时的权限问题- h0 y* K3 p# o5 y: v
3 A+ O+ K& ?7 \+ o T$ b \create database link dl1 connect to scott identified by $ O# i, ^# N5 }3 g, O$ N
; I/ B+ J' d4 |3 f# w5 z
tiger using 'net1'. p/ Y6 g4 K! d, L
) U5 i% o8 a9 B6 A+ _7 `) kORA-01031: 权限不足
1 n5 ^5 D( h4 `8 L! ^& @
8 n X* h, X5 z1 A9 D+ j# o' LSQL> select * from user_sys_privs;
' [2 i' ?# v& m$ Y* k7 Q, U% Y: {
USERNAME PRIVILEGE 7 y: p5 l/ ~( @- a9 x _4 Z V
8 ^3 m% i. y! l' @9 ~( M& U
ADMIN_OPTION
* C p) y" `% x( ?% U S-------------------------
2 v' L$ `3 Q+ a {) t2 f
0 G$ {" f/ s4 B% b9 X4 W4 m; ~5 X---------------------------------------- ------------
0 z1 Y" q7 n4 b, C& ISCOTT CREATE DATABASE LINK
6 H+ D3 D- e* M1 q* Y9 t4 w5 o7 S7 B/ c2 ]) [2 q5 }# ^
NO
! Z3 G- `& d. c+ f5 L$ E, n( }SCOTT UNLIMITED TABLESPACE 5 D y- t s# s+ a! S& y$ F; [
k; [) V3 f0 e# B2 e8 F' |0 h- R
NO
' O! j; i% p) p' X- L" b0 f) x; ^ ~! T
SQL> create database link dl1 connect to scott identified
# \! r4 x8 ?& a! U
* X1 x4 v4 f, A8 W. eby tiger using 'net1';
! H( | {$ v& r& v; N( K! h8 E: q- F& G
create database link dl1 connect to scott identified by
6 P, L I" r/ r1 H; B
- K( J- I Q- D% U i7 Q( Ytiger using 'net1'# b. v7 c- S. D8 e! U
_3 o/ w4 k* A" b
ORA-01031: 权限不足 |
|
/1 
发表于 2023-4-20 17:03
收藏
淘帖
支持！
反对！