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?
greetings 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
