Re: You are not the owner specified for the object 'INFORMATION_SCHEMA'...

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


Hi
Just wanted to add that login with such names (INFORMATION_SCHEMA ) are
highly not recommended as it reserved by MS

More over , try going back to rename the owner (to dbo) and you will fail




"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:eelE9e9$JHA.4168@xxxxxxxxxxxxxxxxxxxxxxx
Eric
Do you have a login INFORMATION_SCHEMA granted access to the master
database? And it is not a member of sysadmin server role db_owner
database role, right?




"Eric" <ericbragas@xxxxxxxxx> wrote in message
news:a3e36600-807f-4250-aff7-2b328eed022a@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I created the procedure master.dbo.Table_Estimated_Rows, but am now
trying to change ownership from "dbo" to "INFORMATION_SCHEMA". When
trying to execute the following statement, I get the following error.
I'm following advice from a SQL Server Central article (http://
preview.tinyurl.com/mmhcm2) on creating utility procedures, but it
doesn't tell how to resolve this error.

What do I need to do in order for the statement to execute
successfully?

EXEC sp_ChangeObjectOwner 'TABLE_ESTIMATED_ROWS', 'INFORMATION_SCHEMA'

gets the following error:

Msg 2710, Level 16, State 1, Line 1
You are not the owner specified for the object 'INFORMATION_SCHEMA' in
this statement (CREATE, ALTER, TRUNCATE, UPDATE STATISTICS or BULK
INSERT).





.

Relevant Pages

  • Re: Running into a roadblock when using execute as and sys.databas
    ... With the execute as clause, ... you use EXECUTE AS LOGIN in the body, and sign them with the certificate. ... CREATE LOGIN imperscert_login FROM CERTIFICATE imperscert ...
    (microsoft.public.sqlserver.security)
  • Re: limit sql agent job resource with resource governor
    ... during the job run and still see the same login. ... If you have a sample classifier function code that uses ... do its work (including "execute as")... ... before Agent executes the EXECUTE AS command. ...
    (microsoft.public.sqlserver.server)
  • Re: limit sql agent job resource with resource governor
    ... I run the DMV query multiple times ... during the job run and still see the same login. ... do its work (including "execute as")... ... before Agent executes the EXECUTE AS command. ...
    (microsoft.public.sqlserver.server)
  • Re: Security hole?
    ... > WSS FAQ at wss.collutions.com ... > added to the site he does not even see this workspace in the list of all ... > also removed that login from sysadmin server role. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Running into a roadblock when using execute as and sys.databas
    ... execute as login = 'LC'; ... However, if LC is created from a certificate, the first statement will ... CREATE LOGIN imperscert_login FROM CERTIFICATE imperscert ...
    (microsoft.public.sqlserver.security)