RE: standard user dbprocedures visibility
"Zabach, Elke" <[email protected]>
| Newsgroups | gmane.comp.db.maxdb |
|---|---|
| Message-ID | <[email protected]> |
Hi, after some further info beside the list, I know that Luca has a user AB owning a schema BC in which a dbproc XY is created. Another user ST does not see the dbproc when selecting DBPROCEDURES restricted to a schema (I hope to the correct BC schema). Now it has to be checked if user ST has some privilege, meaning is able to call this BC.XY-dbproc. If the calling will work, ST should see the dbproc when selecting DBPROCEDURES. If he is not able to call it, then a user AB has to GRANT the dbproc to ST. Elke SAP Labs Berlin Sitz der Gesellschaft/Registered Office: Walldorf, Germany Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Shai Agassi, Léo Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner Registergericht/Commercial Register Mannheim No HRB 350269 Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank. This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation. > -----Original Message----- > From: Luca Calderano [mailto:[email protected]] > Sent: Montag, 5. März 2007 12:20 > To: [email protected] > Subject: standard user dbprocedures visibility > > In order to know which are the dbprocedures defined in a > SCHEMA I use the following query: > > SELECT * > FROM DOMAIN.DBPROCEDURES > WHERE SCHEMANAME = 'schemaXY' > > When I run this query as dbadmin all works fine, > but as I try to run this one as a standard user the query > outputs no result > > Please Help > Luca Calderano > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[email protected]