Kunstkamera
New Member
I need a way to query what permissions a user has on a table. I am wanting to create a custom UI based on which fields a user has the ability to view/edit. I set up the permissions in SQL Server 2000 and have tested that they work. I just need a way to dynamically check which permissions the user that is accessing my asp page has. I looked at the syspermissions table but I can't make any sense out of it. <BR><BR>Any Thoughts...<BR><BR><BR>Thank in advance,<BR><BR>MikeI used the stored procedure sp_column_privileges to get all privileges for a given table. I'm not familiar with using stored procedures so I now face the question of how to query the output of a stored procedure. Can I nest the stored procedure in a select statement. <BR><BR>Exammple:<BR><BR>Select * from (sp_column_privileges tablename) where mycolumn='xx'<BR><BR>Any help would be appreciated.<BR><BR>Thanks,<BR><BR>Mike