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


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: 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: limit sql agent job resource with resource governor
    ... Still doesn't make sense because I could see that the username is correct ... I run the DMV query multiple times ... during the job run and still see the same login. ... do its work (including "execute as")... ...
    (microsoft.public.sqlserver.server)
  • Re: Unable to su as a user, I get: Cannot execute /bin/bash: Permission denied
    ... on the xconsole screen..it lets me login and then bounces me ... execute /bin/bash: Permission denied ... It'll be executed by the user, not root. ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)