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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Hide stored procedure

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
Go to Top of Page

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...
Go to Top of Page

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 permissions

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page

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
Go to Top of Page

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...
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2007-11-13 : 06:05:14
Unplug their monitor

Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson
Go to Top of Page

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]

Go to Top of Page

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 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
Go to Top of Page

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.
Go to Top of Page

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 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...
Go to Top of Page

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
Go to Top of Page

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...
Go to Top of Page

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
Go to Top of Page

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...
Go to Top of Page

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.

Go to Top of Page

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]

Go to Top of Page

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...
Go to Top of Page

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
Go to Top of Page

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...
Go to Top of Page

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 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page
    Next Page

- Advertisement -