Thomas Stegbauer wrote: > i am playing a while with sapdb and try to migrate our software from > sybase to sapdb 7.4.3.17 > > i want a prod and a test environment. for this i created two dba users > in the instance within sqlsto. > > after logging in with the two new users i created the tables > as needed. > what i am missing, is how to grant all the users to the different > tables, cause a: > grant select,update,delete,insert on TEST.* to testuser1 > does not work on the * > > grant select,update,delete,insert on PROD.* to user1 > dito > > what make i wrong?
You are using the syntax known in one database system for another database system. This will often cause some trouble. Please check MAxDB's syntax for GRANT and the privilege specifications there: http://www.sapdb.org/7.4/htmhelp/a4/2938b7248811d3a97d00a0c9449261/frameset.htm And if every privilege for all tables of user test is given to testuser1, why aren't user test and user testuser1 in one usergroup not needing any privilege granting? Or why are there different users? If you really want to grant everything on all tables, you have to write a script for this by your own. I think, we had this discussion before and in the archive there you will find something. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
