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-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.