Solved

sp_addalias and sp_addrolemember

Posted on 2000-05-02
3
1,023 Views
Last Modified: 2008-01-09
addalias was nice in that when objects were created, they were created under dbo.  I tried using addrolemember and added my user to db_owner, but when the objects are created, they are created under that user account.  I want the objects created under dbo.  sp_addalias is still available in 7.x, but they say it's for backward compat.  

REAL QUESTION:  In MS vision, how can I get the same exact benefit as sp_addalias?
0
Comment
Question by:ivanh
  • 2
3 Comments
 
LVL 5

Expert Comment

by:dtomyn
ID: 2770411
My understanding is that you can't.  The best you can do is change the object's owner after creation or create it as "dbo.objectname".
0
 
LVL 1

Author Comment

by:ivanh
ID: 2770744
dtomyn - That answer is acceptable to me.

Lock it and I will award
0
 
LVL 5

Accepted Solution

by:
dtomyn earned 100 total points
ID: 2771265
OK, thanks!  

Also, you will notice that Experts-Exchange now has given the ability to questionnaires to accept a comment as an answer (just for future reference).
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question