Hi

q) I want all access availabe to role EveryoneRole to
PublicReaderRole. Is this correct?
grant control on role::EveryoneRole to PublicReaderRole

q) I want to give access of role to user. Is this correct?
grant control on role::EveryoneRole to EveryoneUser

I'm not sure what 'control' means.

Please .

> q) I want all access availabe to role EveryoneRole to
> PublicReaderRole. Is this correct?
> grant control on role::EveryoneRole to PublicReaderRole

So you want all PublicReaderRole members to have the permissions granted to
EveryoneRole? In that case, add PublicReaderRole to the EveryoneRole:

EXEC sp_addrolemember @rolename = 'EveryoneRole', @membername =
'PublicReaderRole';

> q) I want to give access of role to user. Is this correct?
> grant control on role::EveryoneRole to EveryoneUser

Use sp_addrolemember to add role members:

EXEC sp_addrolemember @rolename = 'EveryoneRole', @membername =
'EveryoneUser';

> I'm not sure what 'control' means.

CONTROL is a very powerful permission and gives the grantee all permissions
on the target. It's normally used to delegate administration tasks rather
than for normal database access. See the Books Online
(http://msdn.microsoft.com/en-us/library/ms191291.aspx).


--
Hope this s.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Riyaz Mansoor" <riyaz.mansoor@gmail.com> wrote in message
news:85438997-5bcf-433e-8879-0fc31bbe18c2@25g2000hsx.googlegroups.com...
>
> Hi
>
> q) I want all access availabe to role EveryoneRole to
> PublicReaderRole. Is this correct?
> grant control on role::EveryoneRole to PublicReaderRole
>
> q) I want to give access of role to user. Is this correct?
> grant control on role::EveryoneRole to EveryoneUser
>
> I'm not sure what 'control' means.
>
> Please .
>
>