| Author |
 Topic  |
|
jonasalbert20
Constraint Violating Yak Guru
Philippines
300 Posts |
 Posted - 11/13/2007 : 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
United Kingdom
1208 Posts |
Posted - 11/13/2007 : 03:13:16
|
you can save it encrypted, is that what you mean?
Em |
 |
|
|
jonasalbert20
Constraint Violating Yak Guru
Philippines
300 Posts |
Posted - 11/13/2007 : 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
Flowing Fount of Yak Knowledge
United Kingdom
1765 Posts |
Posted - 11/13/2007 : 03:21:47
|
By any user , do you mean every user including "sa". You could control it by permissions
Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
|
|
|
|
elancaster
A very urgent SQL Yakette
United Kingdom
1208 Posts |
Posted - 11/13/2007 : 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
Philippines
300 Posts |
Posted - 11/13/2007 : 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... |
Edited by - jonasalbert20 on 11/13/2007 03:39:11 |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
Australia
4970 Posts |
Posted - 11/13/2007 : 06:05:14
|
Unplug their monitor
Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16745 Posts |
Posted - 11/13/2007 : 07:34:26
|
Yes. Don't ever ever create the stored procedure in your SQL Server
KH
Time is always against us
|
|
|
|
DonAtWork
Flowing Fount of Yak Knowledge
2111 Posts |
|
|
rmiao
Flowing Fount of Yak Knowledge
USA
7266 Posts |
Posted - 11/13/2007 : 23:18:06
|
| People still can see the sp in em even don't have exec permission on it. |
|
|
|
jonasalbert20
Constraint Violating Yak Guru
Philippines
300 Posts |
Posted - 11/14/2007 : 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 permissions
Jack 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.aspx
Learn SQL
http://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!
Australia
4970 Posts |
Posted - 11/14/2007 : 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
Philippines
300 Posts |
Posted - 11/14/2007 : 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!
Australia
4970 Posts |
Posted - 11/14/2007 : 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
Philippines
300 Posts |
Posted - 11/14/2007 : 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
Flowing Fount of Yak Knowledge
USA
1464 Posts |
Posted - 11/14/2007 : 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)
Singapore
16745 Posts |
Posted - 11/14/2007 : 23:28:10
|
if it is really that important then only create the stored procedure when required and drop it after that.
KH
Time is always against us
|
|
|
|
jonasalbert20
Constraint Violating Yak Guru
Philippines
300 Posts |
Posted - 11/15/2007 : 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!
Australia
4970 Posts |
Posted - 11/15/2007 : 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
Philippines
300 Posts |
Posted - 11/15/2007 : 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... |
Edited by - jonasalbert20 on 11/15/2007 05:18:47 |
|
|
|
spirit1
Cybernetic Yak Master
Slovenia
11741 Posts |
|
|
Topic |
|
Hide stored procedure
