Database Administration (MOSC)

MOSC Banner

How to give only Select access to a user in Oracle DB

edited Sep 21, 2015 10:01AM in Database Administration (MOSC) 13 commentsAnswered

Hi,

App : 9.1

Tools : 9.1.3.0

DB : Oracle 11G R2

OS- Solaris 10

Here customer is using OBDC connection to connect JDE DB using MS Excel. I want to restrict users to only fetch data from a single table, no update access is given. For that I have used below commands, but yet I can see user can select data from other tables too :

=====================================================

CREATE USER jyoro IDENTIFIED BY jyoro123;

GRANT SUNUSR TO jyoro; (SUNUSR is the role which I have created to allocate users)

GRANT CREATE SESSION TO jyoro;

GRANT SELECT ON PRODDTA.F0101 TO SUNUSR;

=====================================================

Kindly Advise,

Thanks,

Jyotirmoy

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center