| Revoke table access (merged) [message #144700] |
Thu, 27 October 2005 13:23  |
jjs2442728
Messages: 2
Registered: October 2005
|
Junior Member |
|
|
Hi,
I'm trying to revoke permissions to tables to prevent user access via ODBC(excell, access).
from sql plus I log on as the schema owner:
REVOKE ALL ON SYSADM.EMPLOYEE FROM RICHB;
commit;
I receive revoke succedded and commit complete.
I am stil able to access the table info from any sql tool
and excell and access.
any ideas on what is wrong would be greatly appreciated.
Thanks
|
|
|
|
|
|
| Re: Revoke table access [message #145257 is a reply to message #144702] |
Wed, 02 November 2005 01:16  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Instead of revoking permissions from users, try to restrict the programs that the user is using for accessing the database.
For this reading/working on product_user_profile may benefit you.
--Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
