How to give only Select access to a user in Oracle DB
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