PragmaSQL Online gives 10 licences* for FREE to 10 pragmatic T-SQL developers who provide an answer to the following Microsoft Sql Server 2000/2005 question.
QUESTION: How can you test if a database user has at least one permission (like SELECT, EXECUTE or any other) granted for a specified object (table, stored proc, user defined function or view) ?
HOW TO APPLY?
- Register to PragmaSQL Online if you are not a registered user.
- Download the demo version of PragmaSQL
- Send us your answer (T-SQL script) and the demo activation key** from the e-mail address you provided during the registration process
(*)These licences are Promotional licences and are no different than a commercial licence except it is FREE and valid for all PragmaSQL versions with code name Tulip
(**) You can view your demo activation key from PragmaSQL via Main Menu -> Help -> About on the Licence Information page.