Ajit wrote : >Hi, >I have a set of tables created by user1. I want user2 to have access(all rights) to >all tables of user1. (and any more that user1 may later create) is this possible? >(For all practical purposes I need the identical users with different >username/password. I don't want to grant rights to user2 for each individual table of >user1) >Thanks, >Ajit
You may create a usergroup g and two users user1 and user2 as members of that group : CREATE USERGROUP G RESOURCE CREATE USER USER1 PASSWORD USER1 USERGROUP G CREATE USER USER2 PASSWORD USER2 USERGROUP G Both users have all privileges for all tables created by any user of the usergroup. I don't see another solution that makes tables created in the future visible to both users. 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
