Re: Other user standard owner

From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 09/20/02


From: "Andrew J. Kelly" <akelly@targitinteractive.com>
Date: Fri, 20 Sep 2002 10:50:24 -0400


Specify the owner in the CREATE statement. Assuming the owner would be joe
you would do it similar to this:

CREATE TABLE joe.JoesTable (......

--
Andrew J. Kelly   SQL MVP
Targitinteractive, Inc.
"Arvid Mestdagh" <am@cipal.be> wrote in message
news:3ad001c260b2$53e97850$2ae2c90a@phx.gbl...
> Hi,
>
> When creating a table or something else the owner will be
> set to DBO.
> I would like that the owner is someone else, How can I do
> that?
>
> Thank you
> Arvid


Relevant Pages

  • Re: Unix/Linux IP?
    ... The word theft means to take and ... > The original owner is denied the payback for his investment. ... search for "IP theft" shows quite plainly that this is acceptable ... Joe is babbling nonsense when he says that "theft" ...
    (comp.unix.sco.misc)
  • Re: Finding out which account added a workstation to the AD...
    ... Thanks Joe, but the owner of the computer object is listed as "Domain ... I did get a clue from the ACL though about who might be responsible - a user ...
    (microsoft.public.windows.server.security)
  • Re: Why should the infrastructure master for each domain not host the global catalog????.
    ... Joe... ... If all of your DCs in a domain are GCs it doesn't matter. ... infrastructure master for each domain must not host the global catalog." ... was the Schema Owner, Doman role owner, PDC role, Rid Manager and ...
    (microsoft.public.windows.server.active_directory)
  • Re: 4 more years!
    ... discussion is between the Yanks offering 2 and Joe and his agent ... agree, though, that the only explanation for this delay is that Joe is ... Cashman also said this week that the owner still retains decision ...
    (alt.sports.baseball.ny-yankees)
  • Re: Password problem
    ... Log on as joe; ... question - who is (joe is the current owner of all tables, ... Double click the relevant query - what error occurs? ... See if the user from step 3., has full permissions to ...
    (microsoft.public.access.formscoding)

Quantcast