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_MSreplcheck_permission(int @objid, int @type
, int @permissions)
MetaData:
create procedure sys.sp_MSreplcheck_permission(
@objid int,
@type int,
@permissions int)
AS
declare @tablename sysname
declare @ownername sysname
declare @unqual_sourcename nvarchar(540)
select @ownername=SCHEMA_NAME(schema_id) from sys.objects where object_id=@objid
select @tablename=object_name(@objid)
-- bypass this checking for dbo or member of db_owner.
if is_srvrolemember('sysadmin') = 1 or is_member ('db_owner') = 1
return (0)
if @permissions=0
return (0)
select @unqual_sourcename = sys.fn_replreplacesinglequote(@ownername + '.' + @tablename)
-- insert
if @type=1 and @permissions & 1 = 1 and HAS_PERMS_BY_NAME(@unqual_sourcename, 'OBJECT', 'INSERT')=0
return (1)
-- update
if @type=2 and @permissions & 2 = 2 and HAS_PERMS_BY_NAME(@unqual_sourcename, 'OBJECT', 'UPDATE')=0
return (1)
-- delete
if @type=3 and @permissions & 4 = 4 and HAS_PERMS_BY_NAME(@unqual_sourcename, 'OBJECT', 'DELETE')=0
return (1)
return (0)
No comments:
Post a Comment