Re: standard user dbprocedures visibility

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]