Re: Changing of owner of a table

Hari Gupta wrote: > Thanks to every one for their time to reply my query, however, I did a test > to update systable in one of our test environment and guess what ??????? > It changed the owner BUT I could not achived the desired result. > > Wait.. Wait !!!!!! I will explain "desired results". > Infact I wanted to create a role and when I treid to create role, I get an > error as: > "19800: Role name already exists as a user or role." > I then found that some table have the owner with the same name which I > intend to setup as role. There are some reasons to setup role with that name > only. > Having done the update (owner.systables), I still get the same error. Then I > found systabauth also have grantor as that user. > The only thing left now is to bounce engine and check again. Then I think the table you are looking for is sysusers. There is probably an entry in there with the user name you want to use. These entries are manipulated with the GRANT & REVOKE commands at the database level. Again I have seen scripts that update this table, but it is probably not supported. 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.|/ ////////| +----------------------+-----------------------------------+-----------+