Re: Changing of owner of a table

Hari Gupta wrote: > Mark, I checked sysusers table as well and the name I intend to setup for > role is not there either. > Eric already has explained the reason i.e. role name should not be known to > database server (i.e. from sysusers OR OS). > This is a bit tricky. Isn;t ??? I guess it is. The way roles are implemented is as a "special" user, like the user 'public'. So they're all just a bunch of user names, and user creation is done at the OS level, instead of adding an extra layer in the DB server like others do. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+