Hello 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? Thanks for help Regards Rolf _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
