John Doed wrote :
>I have created all my tables under the tables->dbauser node (in sql studio I
>did right click -> new table definitioin on the dbauser's folder).
>Now I am trying to create new users that will access the DB from my
>application. My problem is I
>cannot access ("see") any tables I created with the dba account.
>Should I have created the tables under the Sys node (if so how do I move the
>tables there)? Should I somehow be granting users access to the dbauser's
>tables (how) ?
>I have tried searching the mailing list and online doc's, but am unclear. I
>also created the new users with the dbauser, so the owner is the dba (I was
>hoping I would inherit the dba's tables).
You have to grant the required access privileges to the new users. Example :
GRANT SELECT, UPDATE ON MYTABLE1, MYTABLE2 TO USER1, USER2
For further information see
http://www.sapdb.org/htmhelp/48/f0dac7225811d3a97d00a0c9449261/content.htm
Regards
Thomas
--
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
