Hajo Sandschneider wrote :
>
>Hi everyone!
>
>We are running MaxDB 7.5.01.00 in a Linux environment and experiencing
>problems with the execute privileges for roles assinged to
>users. There
>has been a similar question asked in November which has not
>been answered
>yet.
>
>I have a table 'dummy', a user 'dummyuser', a role 'dummyDelete' and a
>stored procedure 'deleteFromDummy'.
>I have granted all rights on the 'dummy' Table to the role
>'dummyDelete'.
>Also the execute priviligege on the stored procedure has been
>granted to
>the role. Finally 'dummyuser' has been granted the role 'dummyDelete'.
>
>When connecting as 'dummyuser' to the database I am allowed to
>perform a
>select on my 'dummy' table. However, I do not see the procedure's name
>listed inthe Catalog Manager. That's probably why the statement:
> call deletefromdummy(1)
>causes an error like this:
> General error;-4016 POS(1) Unknown procedure
>name:DELETEFROMDUMMY.
>
>Trying to execute the procedure like this:
> call dba.deletefromdummy(1)
>causes a database crash.
>
>Am I missing anything out or is there something not working
>the way it is
>supposed to do?
>
>Any help on this matter is greatly appreciated!
>
>With best regards
>- Hajo Sandschneider
>
First of all you have to enable the role dummyDelete for the session of user
dummyuser. You may
define the role as default role for user dummyuser via the alter user statement or
explicitly enable the role via the set role statement (set role dummyDelete).
Then, when calling the procedure under the account of user dummyuser, you must specify
the schema dba (call dba.deletefromdummy(1)). You cannot omit the schema name like
in the case of the table select, because name resolution is not done via the role
but via the predefined lookup sequence for tables of MaxDB.
Finally a warning : 7.5.01.00 is no longer supported, i.e. no bugs will be fixed for
this version.
Your database crash is a known bug of 7.5.01.00.
Best Regards,
Thomas
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
