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]
