ALTER ROLE

Change the name of a database role.

Syntax
      ALTER ROLE role WITH NAME = new_name

Key
   role       The role to alter.
   new_name   The new name for the role.

Starting in SQL Server 2005 the behavior of schemas changed in that schemas are no longer equivalent to database users.

Example

ALTER ROLE doctors WITH NAME = specialists;
GO

"I don't know if I believe in role models. We're all so different; we're all individuals. In the long run, that's what matters" ~ Wilson Cruz

Related commands:

CREATE ROLE
DROP ROLE
sys.database_role_members
sp_addrolemember - Add members to a role
Equivalent Oracle command: ALTER ROLE


© Copyright SS64.com 1999-2014
Some rights reserved