The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_grantlogin(nvarchar @loginame)MetaData:
create procedure sys.sp_grantlogin @loginame sysname AS -- SETUP RUNTIME OPTIONS / DECLARE VARIABLES -- set nocount on declare @ret int -- return value of sp call declare @exec_stmt nvarchar(4000) -- CHECK PERMISSIONS -- IF (not is_srvrolemember('securityadmin') = 1) begin dbcc auditevent (105, 1, 0, @loginame, NULL, NULL, NULL, NULL, NULL, NULL) raiserror(15247,-1,-1) return (1) end -- DISALLOW USER TRANSACTION -- set implicit_transactions off IF (@@trancount > 0) begin raiserror(15002,-1,-1,'sys.sp_grantlogin') return (1) end -- DISALLOW SQL LOGIN (IE. MUST BE 'DOMAIN\USER') -- if (charindex('\', @loginame) = 0) begin raiserror(15407, -1, -1, @loginame) return (1) end BEGIN TRANSACTION -- LOCK LOGIN -- EXEC %%LocalLogin(Name = @loginame).Lock(Exclusive = 0) -- ADD ROW FOR NT LOGIN IF NEEDED -- if @@error <> 0 -- not found begin execute @ret = sys.sp_MSaddlogin_implicit_ntlogin @loginame if (@ret <> 0) begin -- In case, the login has been created in the window, -- try to lock the login name. We are fine if we succeed. -- EXEC %%LocalLogin(Name = @loginame).Lock(Exclusive = 0) if @@error <> 0 begin ROLLBACK TRANSACTION raiserror(15401,-1,-1 ,@loginame) return (1) end end -- login locked end -- GRANT ACCESS -- EXEC %%LocalLogin(Name = @loginame).SetAccess(HasAccess = 1) COMMIT TRANSACTION -- FINALIZATION: RETURN SUCCESS/FAILURE return (0) -- sp_grantlogin
No comments:
Post a Comment