Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Profiler shows LoginName as 'sa', but 'sa' is disabled on the instance. Expand / Collapse
Author
Message
Posted Tuesday, December 18, 2012 9:13 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 12:26 PM
Points: 53, Visits: 340
Okay, again, so much clarity in hindsight.

I also see another source of my confusion. Apparently, a stored proc is owned by whoever owns the schema it is in, by default, unless its specifically changed via ALTER AUTHORIZATION. So while schema != owner, the schema owner IS the procedure owner, unless it's been specifically changed.

In my case, I'm seeing sa run these things because the proc is in the dbo schema, and the dbo schema is owned by dbo. I guess dbo = sa when it translates to login.

More info on default ownership:



Post #1397873
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse