|
Home > Archive > MS SQL Server > December 2006 > grant select to public
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
grant select to public
|
|
|
| I'm NOT the dbo
but I am allowed to create table/views/UDF
But I can't not do this:
grant select on vw_I_created to public
got this error:
SQL Server Database Error: Grantor does not have GRANT permission.
Is this right ?
| |
| Edgardo Valdez, MCTS / MCITP 2006-12-06, 7:12 pm |
| Your user was not given GRANT permission, which is the ability to grant a
specified permission to other principals.
"klabu" wrote:
> I'm NOT the dbo
> but I am allowed to create table/views/UDF
>
> But I can't not do this:
> grant select on vw_I_created to public
>
> got this error:
> SQL Server Database Error: Grantor does not have GRANT permission.
>
> Is this right ?
>
>
>
| |
| Ajay Rengunthwar 2006-12-07, 12:12 am |
| Hi,
On specific objects if you have to give grant again to other securiy
accounts you can use or ask the admin for the grant with below option
WITH GRANT OPTION
Thanks
Ajay
"Edgardo Valdez, MCTS / MCITP"
< EdgardoValdezMCTSMCI
TP@discussions.microsoft.com> wrote in message
news:B7485BF1-0937-4FE6-97A0- A4486985F37B@microso
ft.com...[color=darkred]
> Your user was not given GRANT permission, which is the ability to grant a
> specified permission to other principals.
>
> "klabu" wrote:
>
|
|
|
|
|