Re: database access

From: jobi (jobi_at_reply2.group)
Date: 06/30/03 

Date: Mon, 30 Jun 2003 11:51:40 +0200

You could use sp_changeobjectowner every time "us" creates objects.

You could also use sp_changedbowner @loginame = us',@map = 'true' . This way
"us" creates dbo-objects. (you will first have to remove "us" from the db)

Check BOL for both sp.
jobi
"Usman" <jathol@hotmail.com> wrote in message
news:#TGgFntPDHA.1072@TK2MSFTNGP10.phx.gbl...
> hi
>
> I created a database with sa rights,
>
> then for security reasons.. I created a users "us" and in database access
> I selected the said data base and checked the 2 top options.
>
> what I assume .. the user "us" is the admin for that data base.. am I
right
> ...
>
> when I go to stored procedures.. it shows "dbo" as owner... and for those
> who are created by "us" the owner is "us"
>
> will it create problems.. for "us" to access objects owned by dbo ??
>
>
> thanks
> Usman
>
>