Friday, March 9, 2012

Permissions

Have the following table (IV00101) with the following fields(itemnmbr, itemname etc.) .

IV00101
----
ItemNmbr
ItemName
...

The following lines work.
PRINT PERMISSIONS()
PRINT PERMISSIONS(OBJECT_ID('tblItem'))

The following line should. but doesn't
PRINT PERMISSIONS(OBJECT_ID('tblItem','ItemNmbr'))

Anyone have any ideas here?Nm, Figured it out. The 2nd parameter belongs to the permissions function instead of the Object_ID.

No comments:

Post a Comment