Security via SQL Stored Procedure

SSsa

Is there any way that i can ascertain security on a document without going through the API...I know there are a couple of tables in the sql database involved but I'm not sure how complicated this query would be or if there is already a stored procedure kicking around in Worksite 8 that could assist.

Would appreciate any help

Thanks

jny

Please use the SDK's API's to do this. Database access is carefully tuned to insure scalability and concurrent access. If you access the database directly, you throw out all of this careful tuning and run a high risk of your system being unavailable. In all, it goes against the core of the WorkSite 3-tier architecture design.