I run sp_Accounts_GetEffectivePermissionList procedure in SQL query analyzer.following error occured.
 but Accounts_RolePermissions

EXEC sp_Accounts_GetEffectivePermissionList table,Accounts_UserRoles table didn't have any values.give some suggession how to rectify this problem.

Server: Msg 201, Level 16, State 4, Procedure sp_Accounts_GetEffectivePermissionList, Line 0
Procedure 'sp_Accounts_GetEffectivePermissionList' expects parameter '@UserID', which was not supplied.











sumathra

As the error message suggests, u need to pass the parameter '@UserID'

the statememnt will be something like:

exec sp_Accounts_GetEffectivePermissionList 'user_id'

Om Prakash