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 |
|
pelicanPaul
Starting Member
14 Posts |
 Posted - 2008-07-28 : 15:26:22
|
Hi,I am a bit new to SQL 2005 but understand the basic concepts of Permission Schemas. My question is this:I am upgrading a bunch of live sites and need to import around 10 tables to each. I need to also set the permissions to these tables. In SQL 2000 I would right click properties and then select permissions and grant permissions. Ofcourse in SQL 2005 it is done via the schema as in:Granting permissions to a schema propagates permissions to every object currently contained in the schema and any objects added to the schema in the future, meaning that the DBA does not need to update permissions for every user any time a new object is added.[url]http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1127863,00.html#schema[/url]BUT WHAT HAPPENS WHEN YOU SIMPLY ADD A NEW TABLE.....????HOW DOES ONE GRANT PERMISSIONS..... via a GRANT SELECT, INSERT.... OR THERE A MORE EFFICIENT WAY????Maybe I should just create an IMPORT script with jsut those tables.Ideas?thanks,Paul |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-28 : 15:32:39
|
| Granting permissions is done through the GRANT command. We don't provide any access to tables but rather only to stored procedures, so we only need GRANT EXEC.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
importing tables and permissions