priviledge in store procedure

bbfung · #1 (**permalink**) 12-02-03, 15:42

Does the SQL in a SQL stored procedure follow the priviledge of the user that create the stored procedure or the user that execute the stored procedure? Any pointer to documentation?

sathyaram_s · #2 (**permalink**) 12-02-03, 16:43

Owner of the SP package , which can be found using the implemetation column of the syscat.procedures and the pkgname column of the syscat.packages tables ...

This is for Version 7 ... Version 8 is a bit different in how it handles SP authorizations ...

Which verion are you on ?

Cheers
Sathyaram

Quote:

Originally posted by bbfung
Does the SQL in a SQL stored procedure follow the priviledge of the user that create the stored procedure or the user that execute the stored procedure? Any pointer to documentation?

bbfung · #3 (**permalink**) 12-03-03, 09:11

Thanks, I am on Version 7. Does application development guide talk about this?

Quote:

Originally posted by sathyaram_s
Owner of the SP package , which can be found using the implemetation column of the syscat.procedures and the pkgname column of the syscat.packages tables ...

This is for Version 7 ... Version 8 is a bit different in how it handles SP authorizations ...

Which verion are you on ?

Cheers
Sathyaram

Internet Services

Web Development

Digital Marketing

Consumer Tech