How to find owner of objects

From: Deborah Bohannon (dbohannon_at_nationalDONOTSENDHEREcareanetwork.com)
Date: 01/15/04 

Date: Thu, 15 Jan 2004 13:42:59 -0600

I need to find the owner of jobs and stored procedures that have been
created and change all of them to be owned by sa. I have recently been
getting a randomly occuring error in some job execution due to SQL not being
able to verify if an object owner really has access.

This the notification message I receive:
STATUS: Failed

MESSAGES: The job failed. Unable to determine if the owner (NCN\dbohannon)
of job Restore DukeEDI_TLog has server access (reason: Could not obtain
information about Windows NT group/user 'NCN\dbohannon'. [SQLSTATE 42000]
(Error 8198)).

I don't understand what would cause this since my account is a sysadmin and
it is the same security that these jobs have always run under.

Thanks in advance,

Deborah

Relevant Pages

  • Re: prefixing the tables with owner name
    ... within stored procedures, if you use owner.objectname - it performs ... if you consistently use owner name on the objects referred within a stored ... sql server can use in-memory plan on every execution. ... > thks in advance. ...
    (microsoft.public.sqlserver.programming)
  • System Stored Procedure Permissions
    ... I have system stored procedures in a databse ... somehow instead of showing the owner as dbo and type as ... database. ...
    (microsoft.public.sqlserver.security)
  • Re: Backup SQL Server DB on Network Drive Big Problem. Please help
    ... Try to change the job owner to sa. ... Tibor Karaszi, SQL Server MVP ... > When I change the owner to "Domain Administrator" to execute the T-SQL ... > of job Test Backup has server access (reason: ...
    (microsoft.public.sqlserver.server)
  • Re: Stored Procedure Owner Issue
    ... "Aaron Weiker" wrote: ... >> analyzer but I can't run these stored procedures from a scheduled job. ... >> to change the owner name for these objects, ... > In order to execute these jobs you have a couple options. ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored Procedure Owner Issue
    ... The stored procedures work when executed from query ... > to change the owner name for these objects, ... In order to execute these jobs you have a couple options. ... login is "raul" and the stored procedure is "test_proc", ...
    (microsoft.public.sqlserver.programming)