By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

How to prevent modifying oracle data through MS access or VC++ sql screen.

P: n/a
How to prevent data updating in oracle tables through MS access or
vc++ sql screen? As of now I am using product_user_profiles. Which is
preventing only through SQL*plus. The same way I want to prevent from
MS access and VC++

Please help

Thanks in advance
Jesu
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Jesu wrote:
How to prevent data updating in oracle tables through MS access or
vc++ sql screen? As of now I am using product_user_profiles. Which is
preventing only through SQL*plus. The same way I want to prevent from
MS access and VC++

Please help

Thanks in advance
Jesu


I certainly no oracle security expert but the security is not controlled
from within a third party link. You need to provide your users with logins
via ODBC or whatever you use that only provides the access you wish. If
you are providing a generic login or superuser type of setup you will not
be able to limit what people can do. I would also look into roles.
Jul 19 '05 #2

P: n/a
I would recommend the use of application id's, and removing individual user rights.
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.