> I have an database that has DBA as the user/owner. > I wish to change this instance to use a newly created > user/owner of my choice. How do I go about reassigning > an existing instance to use a different user/owner and password?
You can use the statements RENAME USER http://www.sapdb.org/7.4/htmhelp/48/f0dab7225811d3a97d00a0c9449261/frameset.htm and ALTER USER http://www.sapdb.org/7.4/htmhelp/48/f0dab1225811d3a97d00a0c9449261/frameset.htm to get almost what you want. Daniel Dittmar -- Daniel Dittmar 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
