dbo. records cannot be modified.

From: Dr.Tulip (Dr.Tulip_at_hotmail.com)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 11:51:27 -0800

Hi rooms,

I want to be able to modify the Microsoft provided records that was created
under dbo. and I struggled with it when playing with security, I can't drop
the owner of the records that was created by dbo. or sa user.

Can someone help me please?

Thank you.

Dr.Tulip.

Relevant Pages

  • Re: sa account privileges in question
    ... I'm not aware of any current Microsoft applications ... security vulnerability you are being asked to assume responsibility for. ... > the created account I set up for them with sa role permissions. ... Cannot use the reserved user or role name 'dbo'. ...
    (microsoft.public.sqlserver.security)
  • Re: Preventing Injection - Client Side
    ... Thank you for making me think about security. ... defaults to dbo but I will be shutting the database window down. ... I tried to import a file to my database under a different username (like ...
    (microsoft.public.sqlserver.security)
  • dbo association
    ... I have restored a data base backup from a different sql ... server that has different users "dbo" for instance. ... will not work for any member of the security group. ...
    (microsoft.public.sqlserver.security)
  • Re: Change UDF Owner
    ... I would prefer to have dbo be the owner. ... I'm trying to get all database objects owned by dbo ... just a security best practice sort of thing. ...
    (microsoft.public.sqlserver.security)
  • Re: Is having dbo as the owner for all application objects a good prac
    ... My practice is to always use dbo. ... doesn't have to specify some user/owner prefix. ... Applying security via ownership is not ...
    (microsoft.public.sqlserver.programming)