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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2005-10-10 : 06:18:12
|
| when i created a new DATABASEi had no stored procedures under the stored procedures sectionwhen i added a user lot of stored procedures starting "dt_" (i assume default ) are added!must i have them?beacuse of security reasons i want a "USER" that i have defined as :public+db_datareader and gave permmisions on certain stored procedures that i have written to execute them - how can i make sure that this "USER" cant access them or an intruder cant make me demage with this stored procedures??thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-10 : 06:29:28
|
| "lot of stored procedures starting "dt_""AFAIK these are part of the monitoring and debugging package - thus will only be added if that "ability" is installedKristen |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-10-10 : 14:32:47
|
| Users that do not belong to the roles dbo or sysadmin won't be able to execute these procedures unless you explicitly grant exec privs to those users.Be One with the OptimizerTG |
|
|
|
|
|
|
default stored procedures