|
|
|
I have a question
|
|||
|---|---|---|---|
|
#18+
The question: You must modify a stored procedure in your database. Several users have been granted to execute this stored procedure. What statement would you execute to perform the modification without affecting the existing permissions? Thank you. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.08.2002, 10:43:45 |
|
||
|
I have a question
|
|||
|---|---|---|---|
|
#18+
ALTER PROCEDURE ? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.08.2002, 10:45:29 |
|
||
|
I have a question
|
|||
|---|---|---|---|
|
#18+
snake, do you answer or ask? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.08.2002, 10:55:49 |
|
||
|
I have a question
|
|||
|---|---|---|---|
|
#18+
igoro1975 а ты сам проверь с ALTER PROCEDURE ;) ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.08.2002, 11:00:42 |
|
||
|
I have a question
|
|||
|---|---|---|---|
|
#18+
RTFM: ALTER PROCEDURE Alters a previously created procedure, created by executing the CREATE PROCEDURE statement, _without_changing_permissions and without affecting any dependent stored procedures or triggers. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.08.2002, 11:04:02 |
|
||
|
|
start [/forum/topic.php?fid=46&msg=32045813&tid=1820866]: |
0ms |
get settings: |
4ms |
get forum list: |
10ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
62ms |
get topic data: |
6ms |
get forum data: |
2ms |
get page messages: |
28ms |
get tp. blocked users: |
1ms |
| others: | 194ms |
| total: | 311ms |
| 0 / 0 |
