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?
hi elke,
thanx for the quick answer
i know mysql and sapdb are different products, i only tried to describe my know to "real databases" :)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
i read before, but it seems i misunderstood something.
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?
the user test has dba rigth und user testuser1, testuser2 and so on should only have select, update, insert and delete in the tables owned by user test.
you are correkt with giving the select aso right to a group and add testuser1, testuser2 aso to this right.
but if i understand your sentence correct.
i can create an usergroup and add a dba user to that group. and non dba users to the same group ?
but this is not possible in the manual and not in sqlstudio
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.
i will search the discussion
thanx thomas
-- # Thomas Stegbauer # http://www.keyserver.de:11371/pks/lookup?op=get&search=0xFF837A1A # Key fingerprint = E469 F5DC 42FB B530 F5CB 99CB CEB2 BFC6 FF83 7A1A
pgp00000.pgp
Description: PGP signature
