SET/CLEAR OWNER in PSQL

[holgermol]

What is the correct statement fot changing the owner from a table or/and database (SET / CLEAR OWNER ?). I used the manual function in Pervasive tool Maintenance for setting table owner until now. But I don't know how can I use in a SQL statement. Thanks. Holger

 

[BeejCyr]

Set Owner = ownername1, ownername2, ownername3, ...

As I understand it, if the DB has Bill, Sam and Helen as the owners, issuing a command like

Set Owner = Bill, Helen
Will clear Sam as an owner of the file.

 

[holgermol]

I tried to execute the following:
Set Owner = 'TEST'

I got an error message:
ODBC Error: SQLSTATE = 37000, Native error code = 0
Syntax Error: Set Owner<< ??? >> = 'TEST'

After then I tried this:
Set Owner = TEST

The same error message:
ODBC Error: SQLSTATE = 37000, Native error code = 0
Syntax Error: Set Owner<< ??? >> = TEST

Note: The database isn't secured. What can be wrong ?
Thanks for help.
Holger

 

[Vancouverite]

Note that Set Owner is new to Service Pack 4. If you are using SP3 or prior, the manual techniques are the only method for setting / clearing owner names.

 

[holgermol]

I downloaded the Patch SP4 from pervasive site. Now I can use the SET OWNER function in a SQL statement. But my target is to clearing all owners. And if I try to execute SET OWNER = '' it gives no error. But I cannot e.g. &quot;edit table design&quot; because an owner ('') is existing. How can I remove complete all users in a statement.

The advice from &quot;aaaaaaaa&quot;: Do you mean if I secure the database, for me its possible to use some modified functions via SQL database (e.g. UPDATE, ALTER TABLE) ? I try out and I desripe the result.

Thanks for your answers. Its very helpfull for me.
Holger