|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
18/04/2008, 09h17
|
#1 |
Messages: n/a
Hébergeur: |
Execute Stored Procedure
Hi There,
What is the minimal right so user can execute stored procedure. db_write, db_read can't make user execute stored procedure TIA, Gun |
|
|
18/04/2008, 11h09
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Execute Stored Procedure
Did you give your user the right "Execute" on that SP?
GRANT EXECUTE ON [dbo].[sp_xxx] TO [some_user] -- Ekrem Önsoy "Gunawan" <jgun98.milis@gmail.com> wrote in message news:uHy8IRSoIHA.4912@TK2MSFTNGP03.phx.gbl... > Hi There, > What is the minimal right so user can execute stored procedure. > db_write, db_read can't make user execute stored procedure > TIA, > Gun > |
|
|
|
21/04/2008, 05h18
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: Execute Stored Procedure
I have not give that right.
If we use this script, we should run this script to every sp that we wrote, shouldn't we? TIA., Gunawan "Ekrem Önsoy" <ekrem@compecta.com> wrote in message news:4752285A-8D48-4856-87F3-7CCA1700EB44@microsoft.com... > Did you give your user the right "Execute" on that SP? > > GRANT EXECUTE ON [dbo].[sp_xxx] TO [some_user] > > -- > Ekrem Önsoy > > > > "Gunawan" <jgun98.milis@gmail.com> wrote in message > news:uHy8IRSoIHA.4912@TK2MSFTNGP03.phx.gbl... >> Hi There, >> What is the minimal right so user can execute stored procedure. >> db_write, db_read can't make user execute stored procedure >> TIA, >> Gun >> > |
|
|
|
21/04/2008, 14h42
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: Execute Stored Procedure
Take a look at this article:
http://www.mssqltips.com/tip.asp?tip=1203 -- Ekrem Önsoy "Gunawan" <jgun98.milis@gmail.com> wrote in message news:u9H6X51oIHA.548@TK2MSFTNGP06.phx.gbl... >I have not give that right. > If we use this script, we should run this script to every sp that we > wrote, shouldn't we? > > TIA., > Gunawan > > "Ekrem Önsoy" <ekrem@compecta.com> wrote in message > news:4752285A-8D48-4856-87F3-7CCA1700EB44@microsoft.com... >> Did you give your user the right "Execute" on that SP? >> >> GRANT EXECUTE ON [dbo].[sp_xxx] TO [some_user] >> >> -- >> Ekrem Önsoy >> >> >> >> "Gunawan" <jgun98.milis@gmail.com> wrote in message >> news:uHy8IRSoIHA.4912@TK2MSFTNGP03.phx.gbl... >>> Hi There, >>> What is the minimal right so user can execute stored procedure. >>> db_write, db_read can't make user execute stored procedure >>> TIA, >>> Gun >>> >> > > |
|
|
|
25/04/2008, 02h27
|
#5 |
|
Messages: n/a
Hébergeur: |
Re: Execute Stored Procedure
Thank you... It's me much...
"Ekrem Önsoy" <ekrem@compecta.com> wrote in message news:43FE7631-34FF-4AE8-AD54-A032697838FF@microsoft.com... > Take a look at this article: > http://www.mssqltips.com/tip.asp?tip=1203 > > -- > Ekrem Önsoy > > > > "Gunawan" <jgun98.milis@gmail.com> wrote in message > news:u9H6X51oIHA.548@TK2MSFTNGP06.phx.gbl... >>I have not give that right. >> If we use this script, we should run this script to every sp that we >> wrote, shouldn't we? >> >> TIA., >> Gunawan >> >> "Ekrem Önsoy" <ekrem@compecta.com> wrote in message >> news:4752285A-8D48-4856-87F3-7CCA1700EB44@microsoft.com... >>> Did you give your user the right "Execute" on that SP? >>> >>> GRANT EXECUTE ON [dbo].[sp_xxx] TO [some_user] >>> >>> -- >>> Ekrem Önsoy >>> >>> >>> >>> "Gunawan" <jgun98.milis@gmail.com> wrote in message >>> news:uHy8IRSoIHA.4912@TK2MSFTNGP03.phx.gbl... >>>> Hi There, >>>> What is the minimal right so user can execute stored procedure. >>>> db_write, db_read can't make user execute stored procedure >>>> TIA, >>>> Gun >>>> >>> >> >> > |
|
|
|
| Outils de la discussion | |
|
|
