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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-13 : 13:05:10
|
| Ron writes "In SQL Server 2000, is there an easy way of setting permissions for a number of tables/views at the same time without having to select each table/view and set the permissions, say for the public role, individually?" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-13 : 13:31:41
|
| I assume you mean in SQL 2000 Enterprise Manager.... if so, then no, you are at the mercy of the GUI.But who needs a GUI? Write a proc to iterate through the tables of your choosing executing the proper command to grant the access.Jay White{0} |
 |
|
|
|
|
|
SQL Permissions