RE: Question related to security

[Boivin, Patrice J]

Title: RE: 9i OCP Upgrade Exam - Again

That would let the account see ANY table in the database, wouldn't it?

 

Pat.

-----Original Message-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 6:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Question related to security

grant select any table to <your developer>

/

 

Shouldn't this work?

Raj

-------------------------------------------------------------
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!

-----Original Message-----
From: Meng, Dennis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 4:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Question related to security

Hi all -

I have an interesting problem at hand - we have a request from a developer that ask to access some tables owned by a user generated by third party app. Since I don't have the password for this user and system/sys do not have admin option on these tables, I can't grant select to the developer. Changing password for this app can be tricky and will be used as last resort. My question is is there anything else I can do to meet this request?

 

Thanks

 

Dennis