OraFAQ Forum: Security » Prevent Access Users From Having Read/Write Access

Home » RDBMS Server » Security » Prevent Access Users From Having Read/Write Access

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

Prevent Access Users From Having Read/Write Access [message #109204]

Tue, 22 February 2005 20:40

dlindz
Messages: 1
Registered: February 2005

Junior Member

Hello all,

I have an Oracle 8i database and I need to control the level of permissions given when connecting via MS Access odbc. I've granted the user only select perms, however they can still add records to tables.

Thanks in advance!

Report message to a moderator

Re: Prevent Access Users From Having Read/Write Access [message #109609 is a reply to message #109204]

Sun, 27 February 2005 03:56

Frank Naude
Messages: 4575
Registered: April 1998

Senior Member

Hi,

That's probably because they connect to the user/ schema that owns these tables. Consider creating a new schema and grant select privs to the new schema.

Best regards.

Frank

Report message to a moderator

Previous Topic:	Security Issue
Next Topic:	Exempt users from FGA policy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 21 11:26:48 CDT 2023