Thread: Create Database Link Privilege
05-27-04, 03:08 #1Registered User
- Join Date
- Mar 2004
Unanswered: Create Database Link Privilege
This system privilege comes with CONNECT role.
While CONNECT is a minimal role which every user is granted, I would not prefer any user trying to CREATE database link to any other database.
How do I ensure that this privilege is not misued. I cannot revoke CONNECT role .
05-27-04, 10:35 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
>While CONNECT is a minimal role
I do not consider the CONNECT role to be "a minimal role".
By default it provides the following:
CONNECT ALTER SESSION NO
CONNECT CREATE CLUSTER NO
CONNECT CREATE DATABASE LINK NO
CONNECT CREATE SEQUENCE NO
CONNECT CREATE SESSION NO
CONNECT CREATE SYNONYM NO
CONNECT CREATE TABLE NO
CONNECT CREATE VIEW NO
If you don't want folks to CREATE DATABASE LINK,
then remove it from the CONNECT role.You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.