Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-08 : 10:03:27
|
| Greg writes "Hi,I was wondering how to make a stored proc. ineditable. There are some like dt_addtosourcecontrol that are disabled but readable in the property dialog - so they are not encrypted. What setting causes this and how can I make my own stored procs behave this way?ThanksGreg" |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-02-08 : 10:34:06
|
| If your users have their own logins then make sure they are not mapping to the db_owner or db_ddladmin roles. Those should be the only two that have permission to issue the "ALTER PROCEDURE" command.Justin |
 |
|
|
|
|
|
locking SQL stored procedures