Rename Database Role 
Author Message
 Rename Database Role

AFAIK, object level permissions will only be scripted when
you script the object and select Script Object Level
Permissions.
Statement level permissions will be scripted with the role
though if you select Script object level permissions - even
if you haven't selected any objects. May not make much sense
but that's how it seems to work.
If you don't want to do something where you include the
objects and then delete those out of the script, you may
need to just write your own script.

-Sue

On Wed, 10 Jul 2002 07:59:48 -0700, "Nick Collins"

Quote:

>Is it possible to rename or create a copy of a user-
>defined role in SQL Server 2000?  I tried to generate a
>SQL script, but the permissions are not generated with the
>script.

>Thank you in advance.

>Nick Collins
>Database Administrator
>Blue Cross Blue Shield of Michigan



Mon, 27 Dec 2004 00:08:59 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Rename role's name

2. Renaming a role

3. Server Roles, Database Roles, Replication

4. Server Roles/Database Roles

5. Server Roles and Database Roles

6. User with server role / database role

7. diffence between Fixed server role and fixed database role

8. DSO created Cube roles not connected to the corresponding Database role

9. Database Role vs Cube Role

10. ALTER DATABASE RENAME DATABASE?

11. net.database is being renamed comp.databases

12. Renaming a Database Connection and Database


 
Powered by phpBB® Forum Software