Re: Security and Views

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Marc Mertens (marc.mertens_at_azlan.com)
Date: 11/25/04 

Date: Thu, 25 Nov 2004 13:31:12 +0100

You can use sp_changeobjectowner to change the owner of a object, this
should solve your problem (you must ensure that all objects involved has the
same owner). There could still be a problem if the tables and the view are
in different databases, in that case the logins that are associated with the
owners of the objects should be the same (unless you have applied sp3a and
disabled cross databases ownership chaining, in that last case there is no
other solution than to give rights also on the tables).

Hopes this helps

Marc

"Michael Kellogg" <mkellogg@WEDELIVERcc3.com> wrote in message
news:Xns95AB6BDD190CEmkelloggWEDELIVERcc3@207.46.248.16...
> "Marc Mertens" <marc.mertens@azlan.com> wrote:
> > Do the view and the underlying tables hava all the same owner, if not
> > ensure that view and table have the same owner.
> > It could be usefull if you lookup 'broken ownership chain rule' in the
> > Books Online
>
> As a matter of fact, no. The tables are all owned by "dbo" and all the
> views, having been created by me, have my domain and login name in front
of
> them, which is annoying. How can I change them to be system-owned? Would
> this fix my access problem?
>
> --
> Michael Kellogg
> CC3 West DP Programming
> Running VFP 6-SP4

Relevant Pages

  • SQL 2000 in a Workgroup - Problem with DBO.xxx
    ... I have a win xp pro workgroup using simple sharing (No Logins ... Neccessary) and have a Database owner issue. ... I have a seperate machine called "Server" with win xp pro on it and SQL ... Firstly create the DB from another machine using Enterprise Manager ...
    (microsoft.public.sqlserver.security)
  • Re: Rev 22 on the Prime emulator
    ... It didnt even have user logins! ... Well that sounds like a large quivering pile of poo emitting great ... didn't know the owner or non-owner password, ...
    (comp.sys.prime)
  • Re: builtinadministrators in the db_owner role
    ... You can change the db owner using the sp_changedbowner stored procedure. ... > In the Logins dialog, I can't drop the account from any ... > owner' box because the account is called 'dbo' & you can't ... > have a 'normal' account in a database with that name. ...
    (microsoft.public.sqlserver.security)
  • Re: Create table & deny delete table
    ... The middle component of the 3 part name is the owner of the table, ... user creates a table dbname.dbo.table_name, it is now owned by dbo. ... permissions, are granted to users in a database, not to logins. ...
    (microsoft.public.sqlserver.security)