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