Alias to object owner in SQL Server 7

Alias to object owner in SQL Server 7

Post by Manuel Droesle » Wed, 07 Apr 1999 04:00:00

Hello All,

how can I alias a db user in SQL Server 7 to another user who is the owner
of tables with the result that the aliased user no longer needs to use the
owner prefix when accessing those tables??? In 6.5 this was simple by using
sp_addalias(). In 7.0 I can execute sp_addalias() with no error, but the
owner prefix is required anyway.

Thanks for any help.



1. SQL Server 7 object 'Owner' problem


Resently I had to upgrade the security level on the SQL server I am
administrating. I have all my users logging in trough a Win NT User Group.
The user group has no "server wide" priviligies like the "system
administrator" it had before. In stead of that the group have different
rights on each database, some db's they have both public and db-owner on
others only db-datareader....

My problem is that I often use the dbname.dbo.objectname naming when I
access objects across the databases. But now all new objects get a owner
name equal to the creater and you have to write something like this for each
object: databasename.[ntdomain\ntuser].objectname and I find that very

Is there anyway to prevent the owner from being the username and setting it
to dbo?

Is there anyway to change the owner from [ntdomain\ntuser] to dbo????

Venlig Hilsen
Jens Hermann

2. Raise_application_error

3. SP2 blues: owner object not seen by owner unless fully qualified

4. Which Query is Faster

5. t-sql to create object w/ different owner

6. Request for Info: Jet engine access for Delphi

7. Change Object Owner in SQL 6.5

8. page-number reset

9. Change Object Owner under SQL 6.5 ??

10. Table owner Mandatory in SQL for SQL Server 7.0

11. MS SQL-Server 6.5: change table owner

12. SQL Server Copy Object Task: include dependent objects

13. SQL Server forcing the owner name to be entered all of a sudden in table name