Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial


Permissions

Function permissions needs to be upgraded to has_perms_by_name:

Microsoft SQL Server 2000

permissions ( <expression1>)
permissions ( <expression1>, <expression2>)

Microsoft SQL Server 2008

has_perms_by_name ( object_name(<expression1>), 'object', 'any' )
has_perms_by_name ( object_name(<expression1>), 'object', 'any', <expression2>, 'column' )

Examples:

Microsoft SQL Server 2000:

SELECT name FROM sysobjects WHERE permissions(id)=1

Microsoft SQL Server 2008:

SELECT name FROM sys.objects WHERE permissions(object_id)=1

Microsoft SQL Server 2000:

SELECT o.name FROM sysobjects o,syscolumns c WHERE permissions(o.id,c.name)=1

Microsoft SQL Server 2008:

SELECT o.name FROM sys.objects o,sys.columns c WHERE permissions(o.object_id,Isnull(c.name, ''))=1

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.