Home » RDBMS Server » Security » restricted access in Oracle ???
restricted access in Oracle ??? [message #117120] Mon, 25 April 2005 04:42 Go to next message
chieulee
Messages: 10
Registered: April 2005
Junior Member
Hi all,

can anyone briefly explain two different ways in which restricted access can be provided in Oracle?

thanks a million !
Re: restricted access in Oracle ??? [message #117371 is a reply to message #117120] Tue, 26 April 2005 15:03 Go to previous message
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
Senior Member
Well, I only know of one that doesn't incorporate the application suite (iAS):

Restrict Access to Tables/Views:
 1. Through privelage grants on the table/view

Restrict Access in the Application:
 1. Through Fine Grain Access Control
 2. Dynamic view population (this is my own method, DO NOT GIVE THIS AS AN ANSWER IN AN INTERVIEW!! I cannot stress that enough)
 3. Through responsibility/user definitions



HTH,
Steve
Previous Topic: Dynamically Populating View Data based on User
Next Topic: urgent... password problem for oracle 10g on linux
Goto Forum:
  


Current Time: Mon Aug 03 16:22:03 CDT 2020