permissions of procedure
Hello does anyone know how to find the permissions of a procedure.e,g is it executable. I need this information to prove that a proc has right permissions. I though the information would be in the table sysprocedures but it is not
Use dbscema -d dbName -f procname -p all -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of KARL OLIVER Sent: Friday, 12 November 2010 5:39 AM To: ids@iiug.org Subject: permissions of procedure [21933] Hello does anyone know how to find the permissions of a procedure.e,g is it executable. I need this information to prove that a proc has right permissions. I though the information would be in the table sysprocedures but it is not ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. *************************************************************** This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Land and Property Management Authority. This email message has been swept by MIMEsweeper for the presence of computer viruses. *************************************************************** Please consider the environment before printing this email.
You can also look at sysprocauth table -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Stuart McCann Sent: Friday, 12 November 2010 8:50 AM To: ids@iiug.org Subject: RE: permissions of procedure [21934] Use dbscema -d dbName -f procname -p all -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of KARL OLIVER Sent: Friday, 12 November 2010 5:39 AM To: ids@iiug.org Subject: permissions of procedure [21933] Hello does anyone know how to find the permissions of a procedure.e,g is it executable. I need this information to prove that a proc has right permissions. I though the information would be in the table sysprocedures but it is not ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. *************************************************************** This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Land and Property Management Authority. This email message has been swept by MIMEsweeper for the presence of computer viruses. *************************************************************** Please consider the environment before printing this email. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. *************************************************************** This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Land and Property Management Authority. This email message has been swept by MIMEsweeper for the presence of computer viruses. *************************************************************** Please consider the environment before printing this email.
Thanks for that Stuart