Permission question 1

[slok]

I have created a set of tables using a user called PADMIN
and is now writing a PL/SQL package that have various logic
for different scenarios.

How can I create the package such that any logged in user
will be able to carry out the tasks BUT direct entry via SQL for such users (other than PADMIN) will not be permitted.

 

[slok]

just to add on, should permission for things like triggers be given to PADMIN or normal users?

 

[sem]

Normally your package will be executed under creators(PADMIN) writes so the executor needs only package execution permission.