Owner granting permissions on his objetcs

Tom
add
grant control on schema::dbo to a







"Tom" wrote in message
news:1C3EB310-7915-467C-852C-EF6CFC65CB57@microsoft.com...
> hi all,
> I've run the follwing code:
>
> use adventureworks
> go
> create login a with password = '123'
> create login b with password = '123'
> create user a
> create user b
> go
> grant create table on database::adventureworks to a
> grant alter schema::dbo to a
> grant select on schema::dbo to a
>
> execute as login = 'a'
>
> create table dbo.aTab (col1 int)
>
> grant select on object::dbo.aTab to b
>
> the grant statment failed.
> how come an object owner can't grant select permission on his object to
> other db users?
> what does it take, at the minimum, to allow him to do that?
>
> thanks
> tom
>
>
>
>

hi Uri,
grant control makes the user have full control on the chema.
I only want him to be able to grant other users select permission on his
table.
thanks,
tom.


"Uri Dimant" wrote:

> Tom
> add
> grant control on schema::dbo to a
>
>
>
>
>
>
>
> "Tom" wrote in message
> news:1C3EB310-7915-467C-852C-EF6CFC65CB57@microsoft.com...
> > hi all,
> > I've run the follwing code:
> >
> > use adventureworks
> > go
> > create login a with password = '123'
> > create login b with password = '123'
> > create user a
> > create user b
> > go
> > grant create table on database::adventureworks to a
> > grant alter schema::dbo to a
> > grant select on schema::dbo to a
> >
> > execute as login = 'a'
> >
> > create table dbo.aTab (col1 int)
> >
> > grant select on object::dbo.aTab to b
> >
> > the grant statment failed.
> > how come an object owner can't grant select permission on his object to
> > other db users?
> > what does it take, at the minimum, to allow him to do that?
> >
> > thanks
> > tom
> >
> >
> >
> >
>
>
>