| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: GRANT/PRIVILEGE PROBLEM: URGENT
My English is quite bad and I'm afraid I haven't understood everithing:
Sybrand Bakker escribió:
> I will describe the following situation, which is how it should work un=
der
> Oracle 7.
> In this particular app no end-user has direct insert, update, delete
> privileges. Everything is done through packages. The packages are owned=
by
> the owner of the tables. Packages run with the privileges of the owner
> automatically, roles are not being used. In this case no extra privileg=
es
> need to be given to end-user. That problem should only arise when the
> package are owned by an user that is not the table owner.
If I understood right, granting execute privileges to a role won't work when the package owner has privileges over the table accesed, will it? Or does it depend on granting "select" privileges to a role or to a user?
> Thomas Kyte posted several examples in the last few months.
I haven't been connected for months. :((
Best regards.
-- =
Julio Negueruela
DBA Servicio Informático
Universidad de La Rioja - Spain Telf: 941-299179 Fax: 941- 299180
 |
 |