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 |
|
khan
Starting Member
1 Post |
 Posted - 2007-09-25 : 17:02:36
|
| I have give permission to one SQL Server 2005 user account on a table in my database. i want to script that or any permission i have on table.my question is, how to create that script in SQL server 2005. if i right click the table -> select "script table as" and select "create to" new query editor, it only creates script for creating the table and doesnt include the permission any account have on that table.....how to do that ? plz help |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-25 : 17:12:56
|
Have a look at Tools -> Options -> Scripting settings.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
Scripting table permissions