Re: standard user dbprocedures visibility

Unfortunately I've used roles for granting ...

I've tried using "direct" granting to users and it worked !

Thanks for your preciuos help

Luca Calderano

----- Original Message ----- 
From: "Zabach, Elke" <[email protected]>
To: "Luca Calderano" <[email protected]>; <[email protected]>
Sent: Thursday, March 08, 2007 1:56 PM
Subject: RE: standard user dbprocedures visibility


> Hallo,
>
> which Kernel-version are you using?
>
> And we unfortunately have to say that even the newest version has a bug 
> concerning dbprocs whose privileges are granted to a role. Such dbprocs 
> will not be shown via select from dbprocedures.
> This bug will be fixed within the next versions.
>
> Dbprocs granted directly to a user are shown (according to code-inspection 
> and test).
>
> Did you use roles for granting?
>
>  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: Donnerstag, 8. März 2007 10:24
>> To: Zabach, Elke; [email protected]
>> Subject: 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]
>>
>>
> 

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]