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.
| Author |
Topic |
|
shubhada
Posting Yak Master
117 Posts |
 Posted - 2009-03-18 : 01:07:19
|
| Consider I have 10 Stroed procedures, 10 views , 10 tables and 2 Users ('XYZ' and 'ABC')out 10 Sps , User 'XYZ' have execute permission on 5 sps and 'ABC' have permission on remaining Sps.when I am trying to generate the scripts in SQL 2005 for SPs , it is not showing following statementGrant exceute on SP_name to 'XYZ'Can you plz tell me how I can generate the scripts with permission?SQLTeam |
|
|
|
|
|
Script Generation