Rad Only Access Question

[dinzana]

Hello All,

Is it possible to grant a user "read only access" to stored procedures / packages / functions?

Thanks for your time.

dinzana

 

[carp]

No - you can't "read" these object; only CREATE, EXECUTE, or DROP them.

 

[ManjulaMadhu]

or maybe, you can try to give "read-only" ie select access on the tables that are in the objects.

 

[sem]

When you obtain the right to EXECUTE stored procedure, you do not obtain the right to modify it automatically. You may also grant SELECT ANY TABLE or explicit grant select on dba_source to allow somebody view source of SP without the right to execute or modify it.

Regards, Dima