SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Hide stored procedure
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 3

jonasalbert20
Constraint Violating Yak Guru

Philippines
300 Posts

Posted - 11/13/2007 :  03:08:21  Show Profile  Send jonasalbert20 a Yahoo! Message  Reply with Quote
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  Show Profile  Reply with Quote
you can save it encrypted, is that what you mean?

Em
Go to Top of Page

jonasalbert20
Constraint Violating Yak Guru

Philippines
300 Posts

Posted - 11/13/2007 :  03:16:22  Show Profile  Send jonasalbert20 a Yahoo! Message  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2060 Posts

Posted - 11/13/2007 :  03:21:47  Show Profile  Visit jackv's Homepage  Reply with Quote
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

United Kingdom
1208 Posts

Posted - 11/13/2007 :  03:22:09  Show Profile  Reply with Quote
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

Philippines
300 Posts

Posted - 11/13/2007 :  03:38:06  Show Profile  Send jonasalbert20 a Yahoo! Message  Reply with Quote
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
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

Australia
4970 Posts

Posted - 11/13/2007 :  06:05:14  Show Profile  Visit Merkin's Homepage  Reply with Quote
Unplug their monitor

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

khtan
In (Som, Ni, Yak)

Singapore
17627 Posts

Posted - 11/13/2007 :  07:34:26  Show Profile  Reply with Quote
Yes. Don't ever ever create the stored procedure in your SQL Server


KH
Time is always against us

Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2161 Posts

Posted - 11/13/2007 :  08:33:23  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 11/13/2007 :  23:18:06  Show Profile  Reply with Quote
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

Philippines
300 Posts

Posted - 11/14/2007 :  20:56:30  Show Profile  Send jonasalbert20 a Yahoo! Message  Reply with Quote
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!

Australia
4970 Posts

Posted - 11/14/2007 :  21:23:28  Show Profile  Visit Merkin's Homepage  Reply with Quote
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

Philippines
300 Posts

Posted - 11/14/2007 :  21:32:04  Show Profile  Send jonasalbert20 a Yahoo! Message  Reply with Quote
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!

Australia
4970 Posts

Posted - 11/14/2007 :  23:05:03  Show Profile  Visit Merkin's Homepage  Reply with Quote
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

Philippines
300 Posts

Posted - 11/14/2007 :  23:09:06  Show Profile  Send jonasalbert20 a Yahoo! Message  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
1464 Posts

Posted - 11/14/2007 :  23:12:49  Show Profile  Send dataguru1971 an AOL message  Send dataguru1971 a Yahoo! Message  Reply with Quote
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)

Singapore
17627 Posts

Posted - 11/14/2007 :  23:28:10  Show Profile  Reply with Quote
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

Go to Top of Page

jonasalbert20
Constraint Violating Yak Guru

Philippines
300 Posts

Posted - 11/15/2007 :  00:33:42  Show Profile  Send jonasalbert20 a Yahoo! Message  Reply with Quote
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!

Australia
4970 Posts

Posted - 11/15/2007 :  01:03:08  Show Profile  Visit Merkin's Homepage  Reply with Quote
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

Philippines
300 Posts

Posted - 11/15/2007 :  01:22:04  Show Profile  Send jonasalbert20 a Yahoo! Message  Reply with Quote
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
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 11/16/2007 :  07:40:06  Show Profile  Visit spirit1's Homepage  Reply with Quote
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
Page: of 3 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.36 seconds. Powered By: Snitz Forums 2000