The problem is that the user ST has the EXECUTE privilege on the dbproc.
Maybe ST should have some other privilege ?
Which one ?
Bye
Luca Calderano
----- Original Message -----
From: "Zabach, Elke" <[EMAIL PROTECTED]>
To: "Luca Calderano" <[EMAIL PROTECTED]>; <[email protected]>
Sent: Thursday, March 08, 2007 9:45 AM
Subject: RE: standard user dbprocedures visibility
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]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
