OraFAQ Forum: Security » restricted access in Oracle ???

Home » RDBMS Server » Security » restricted access in Oracle ???

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

restricted access in Oracle ??? [message #117120]

Mon, 25 April 2005 04:42

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 !

Report message to a moderator

Re: restricted access in Oracle ??? [message #117371 is a reply to message #117120]

Tue, 26 April 2005 15:03

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 18:42:05 CDT 2023