Rolf Scherer wrote :
>I think I have found a bug in the statement "grant role" respectively in the
>system-view tableprivileges (DB-version 7.3 and 7.4 Client SQL Studio and
>JDBC).
>You can reproduce the "bug" with the following commands (login as dba):
>create user user1 password pwd standard
>create role role1
>grant role1 to user1
>select * from tableprivileges
>Now you will get the following error:
>-> [-3016]: Invalid numeric constant
>Try now:
>revoke role1 from user1
>select * from tableprivileges
>.. and everything is ok
>What is the problem?
There's a bug in the definition of the view tableprivileges. You can
avoid the problem if you change the definition of tableprivileges in
the files XDD.py and XDD.ins. Please substitute
AND TYPE NOT IN('SEQUENCE','DBPROC')
by
AND TYPE NOT IN('SEQUENCE','DBPROC','ROLE')
and reload the system tables.
Regards,
Thomas
--
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
