Noah J SILVA wrote:

...
> Also, is it possible to add a user to a usergroup with ALTER 
> USER or some 
> similar method, or does the user have to be DROPped and 
> CREATEd again? (I 
> couldn't see such an option in SAPDB 7.4 reference guide).

A user has to be dropped and created anew to be able to
put him into a usergroup.

Otherwise all the objects of the user had to be changed 
to objects of the usergoup, naming conflicts had to be solved,
privileges and view-texts changed accordingly, trigger and
dbprocs where the owner (the old user) was specified in had
to be changed,   ....   

Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to