Hi ,how to give permission to stored procedure
-
Hi , hw can i give permission so that no one can change my code in stored procedure , and only particular member insert , update , delete my stored procedure which i make in my own database. Thanx in Advance
-
Hi , hw can i give permission so that no one can change my code in stored procedure , and only particular member insert , update , delete my stored procedure which i make in my own database. Thanx in Advance
You create specific database users, then let the clients connect to the db with the appropriate username & password
-
You create specific database users, then let the clients connect to the db with the appropriate username & password
Harvey Saayman wrote:
clients connect to the db with the appropriate username & password
Or use a trusted connection - Must better than exposing passwords in connection strings.
Recent blog posts: *SQL Server / Visual Studio install order *Installing SQL Server 2005 on Vista *Crazy Extension Methods Redux * Mixins My Blog
-
Hi , hw can i give permission so that no one can change my code in stored procedure , and only particular member insert , update , delete my stored procedure which i make in my own database. Thanx in Advance
allow users only to trigger your store procedures, if you only build reports procedures they cannot change data.
nelsonpaixao@yahoo.com.br trying to help & get help