If you are doing this via the web, then you can use the CF Administrator to do this. Select the DSN that you want to execute only teh Sp, make sure that you chek the Stored Procedures check box. If you are talking about using enterprise manager, then you would need to create a login for the users and allow only SP permissions on the database.
---------- Original Message ---------------------------------- From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 1 May 2002 09:36:54 -0400 does nayone know of a way to allow a user to only have permission to execute stored procedures in sql server and not select, update, insert, delete permissions directly? i want people to only be able to access the data in my database from a sp and not directly using select, update, insert, delete. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
