grant permissions not like in mysql?
Thomas Stegbauer <[email protected]>
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Organization | Tronic Planet Datendienst GmbH |
| Message-ID | <[email protected]> |
hi list, 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
signature.asc
(application/pgp-signature, 252 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE/Mon0zrK/xv+DehoRAl9eAKCqvxEsFmRbQhIGLR1ut0m5rKxtGACgpuXg ij5QIr2OnTOT07K4MBSQCPU= =jI8f -----END PGP SIGNATURE-----