stored procedure - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

stored procedure

Author

Topic

cwtriguns2002
Constraint Violating Yak Guru

272 Posts

Posted - 2007-07-05 : 21:54:52

Hi all. I have a question about encryption of SP.
Is it possible to create a user and password then the Sp should be encrypted. Then, to decryp the sp, the user should enter the user and password.

-Thanks

-Ron-

"A logician trying to explain logic to a programmer is like a cat trying to explain to a fish what it's like to get wet."

Kristen
Test

22859 Posts

Posted - 2007-07-06 : 02:21:27

Do you mean you want to encrypt user passwords? or the source code of the Stored Procedure?

Kristen

cwtriguns2002
Constraint Violating Yak Guru

272 Posts

Posted - 2007-07-06 : 03:13:38

the source code of the stored procedure. what is in my mind is, if i want to decrypt / modify my SP, i just open it with the use of username and password. Is it possible?

-Ron-

"A logician trying to explain logic to a programmer is like a cat trying to explain to a fish what it's like to get wet."

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-06 : 03:22:04

Yes, in a zip file or other source file storage.
In SQL Server, you have to use the WITH ENCRYPTION keyword.

Peter Larsson
Helsingborg, Sweden

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-07-06 : 03:22:19

quote:
i just open it with the use of username and password

This feature is not available in sql server. However there are 3rd party tools that do that. Do a google for it.

There is also a member here that has something like that checkout activecrypt's profile

KH
[spoiler]Time is always against us[/spoiler]

cwtriguns2002
Constraint Violating Yak Guru

272 Posts

Posted - 2007-07-06 : 03:55:10

cant open the link specified. ill try later in cafe :P

-Ron-

string strGame = "";
try{
strGame = "I like to play MU psychic-doom";
}
catch(Exception e){
MsgBox("I like MU");
}
Finally{
MsgBox("I love MU");
}

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-07-06 : 03:57:26

quote:
cant open the link specified

Can't open ? That is just the user profile page in this site.

KH
[spoiler]Time is always against us[/spoiler]

cwtriguns2002
Constraint Violating Yak Guru

272 Posts

Posted - 2007-07-06 : 04:01:09

yes. but can't open this http://www.activecrypt.com

should it be?

-Ron-

string strGame = "";
try{
strGame = "I like to play MU psychic-doom";
}
catch(Exception e){
MsgBox("I like MU");
}
Finally{
MsgBox("I love MU");
}

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-07-06 : 04:07:38

try here http://www.xpcrypt.com/

KH
[spoiler]Time is always against us[/spoiler]

cwtriguns2002
Constraint Violating Yak Guru

272 Posts

Posted - 2007-07-06 : 04:14:42

so sorry KH. can't open any links except SQL Team.

-Ron-

string strGame = "";
try{
strGame = "I like to play MU psychic-doom";
}
catch(Exception e){
MsgBox("I like MU");
}
Finally{
MsgBox("I love MU");
}

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-07-06 : 05:03:36

quote:
Originally posted by cwtriguns2002

so sorry KH. can't open any links except SQL Team.

-Ron-

string strGame = "";
try{
strGame = "I like to play MU psychic-doom";
}
catch(Exception e){
MsgBox("I like MU");
}
Finally{
MsgBox("I love MU");
}

Your company firewall must have an exception for SQLTeam !

KH
[spoiler]Time is always against us[/spoiler]

Kristen
Test

22859 Posts

Posted - 2007-07-06 : 06:45:03

"In SQL Server, you have to use the WITH ENCRYPTION keyword"

This removes the source code from SQL server, and encrypts the Stored Procedure. But there is no user-specific decryption - in fact there is no decryption at all, so you need to keep the source code somewhere safe.

We put ours in SubVersion, and allocate permission to specific "folders" to appropriate developers - so developers only see what they are allowed to change.

Kristen

bakerpkb
Starting Member

1 Post

Posted - 2007-07-06 : 13:29:51

i am trying to create a "temp" sql table inside a source pgm. I need to load it up then go back and read and delete it on exit of source. Need to know the basic requirements on how to set this up, please?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-07-06 : 22:14:22

bakerpkb,

please start a new thread for you question

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources