Author |
Topic |
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2007-11-13 : 03:08:21
|
Is it possible to hide a stored procedure? Not visible to any user?Want Philippines to become 1st World COuntry? Go for World War 3... |
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-11-13 : 03:13:16
|
you can save it encrypted, is that what you mean?Em |
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2007-11-13 : 03:16:22
|
nope... what I want is to make the stored procedure not visible. encrypted stored procedure can be seen.Want Philippines to become 1st World COuntry? Go for World War 3... |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-11-13 : 03:21:47
|
By any user , do you mean every user including "sa". You could control it by permissionsJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-11-13 : 03:22:09
|
if you created it under a different owner, would they not see it then? other than admins of course?Em |
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2007-11-13 : 03:38:06
|
Thanks for your reply.Yes other than admins of course. But is it possible to hide the stored procedure from any users? any means any.I just have to save a text file for my hidden stored procedure so that I will be able to edit it from time to time.Want Philippines to become 1st World COuntry? Go for World War 3... |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2007-11-13 : 06:05:14
|
Unplug their monitorDamian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-13 : 07:34:26
|
Yes. Don't ever ever create the stored procedure in your SQL Server KH[spoiler]Time is always against us[/spoiler] |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-11-13 : 08:33:23
|
quote: Originally posted by jackv By any user , do you mean every user including "sa". You could control it by permissionsJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com
Here is your answer! oh wait, i quoted it, now i just need to rephrase it.By using permissions, you could achieve this.There, much better.[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-13 : 23:18:06
|
People still can see the sp in em even don't have exec permission on it. |
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2007-11-14 : 20:56:30
|
quote: Originally posted by DonAtWork
quote: Originally posted by jackv By any user , do you mean every user including "sa". You could control it by permissionsJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com
Here is your answer! oh wait, i quoted it, now i just need to rephrase it.By using permissions, you could achieve this.There, much better.[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp
But is it possible to hide the stored procedure from any users? any means any.hidden? invisible? unseeable?from wordweb dictionary...Impossible or nearly impossible to see; imperceptible by the eye.There, much better.Want Philippines to become 1st World COuntry? Go for World War 3... |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2007-11-14 : 21:23:28
|
Lets just say "no" and you can get on with your day. If you don't want your users to even see that the procs exist, don't give them SQL Server management tools.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2007-11-14 : 21:32:04
|
There are some cases and reasons why we don't want other users including myself not to let them see the confidential stored procedure you've created. From time to time your co-developer needs to access the database where you're stored procedure resides. Of course, not allowing them to use SQL Server management tools is not an option either unplugging the monitor . Any comments and suggestion is highly appriciated. Want Philippines to become 1st World COuntry? Go for World War 3... |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2007-11-14 : 23:05:03
|
If you don't trust them, fire them. Or give them a copy of the DB every day with the secret stuff removed. You're basically spending a lot of time fighting your way around a problem you shouldn't have.Or am I being overly grumpy Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2007-11-14 : 23:09:06
|
Or am I being overly grumpy Perhaps Any suggestion from others?Want Philippines to become 1st World COuntry? Go for World War 3... |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-14 : 23:12:49
|
I can only imagine what highly secretive task is being completed by a procedure that must be kept secret from everyone else--especially a co-developer. The only reason for such secrecy is more suspect than allowing users to see it. Does it store the bonus plan calculations or something?There really is no way to do it AND keep the procedure stored on the server. Poor planning on your part does not constitute an emergency on my part. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-14 : 23:28:10
|
if it is really that important then only create the stored procedure when required and drop it after that. KH[spoiler]Time is always against us[/spoiler] |
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2007-11-15 : 00:33:42
|
quote: Originally posted by dataguru1971 I can only imagine what highly secretive task is being completed by a procedure that must be kept secret from everyone else--especially a co-developer. The only reason for such secrecy is more suspect than allowing users to see it. Does it store the bonus plan calculations or something?There really is no way to do it AND keep the procedure stored on the server. Poor planning on your part does not constitute an emergency on my part.
It depends on the business logic and principles. Especially in extreme programming. With the time to time change or update of your application, later you come up with a process of secrecy based on my experience I have just acquired by my client to limit the access of some operations. Yes some are money matters. If I will create my stored procedure on my application. The code is visible to my co-developer. Any help will be greatly appreciated.Want Philippines to become 1st World COuntry? Go for World War 3... |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2007-11-15 : 01:03:08
|
I'm sorry, but that is a load of crap. Extreme Programming... so you do pair programming ? and you create unit tests to verify your code ?If so, you're going to need to stab your coworkers in the eye so they can't see what you're doing.If not, you aren't doing "Extreme Programming", you're probably just developing without a spec.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2007-11-15 : 01:22:04
|
quote: Originally posted by Merkin I'm sorry, but that is a load of crap. Extreme Programming... so you do pair programming ? and you create unit tests to verify your code ?If so, you're going to need to stab your coworkers in the eye so they can't see what you're doing.If not, you aren't doing "Extreme Programming", you're probably just developing without a spec.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson
Thanks, any other suggestions and comments?Want Philippines to become 1st World COuntry? Go for World War 3... |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-16 : 07:40:06
|
oh for the love of god... you CAN'T do what you want to do._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
Previous Page&nsp;
Next Page
|