**Grant suitable permission**

Hi
I'm working with SQL server 2000,and I want to grant one of my login to
have following permission to DB1:
login1 should be able to "create table",read from all tables in DB1 and
insert and update and delete just for 3 tables(for example:
customer,books,teachers)
once I selected("public","datareader",and manually checked the insert and
delete and update check box in front of the name above 3 tables).
it granted permission as I expected to login1 but no table creation.
how ca I add "creation" to my permission?
any help would be thankful.Read
Statement Permissions in BOL. You can give permissions to statements also
--
Regards
R.D
--Knowledge gets doubled when shared
"R-M" wrote:

> Hi
> I'm working with SQL server 2000,and I want to grant one of my login to
> have following permission to DB1:
> login1 should be able to "create table",read from all tables in DB1 and
> insert and update and delete just for 3 tables(for example:
> customer,books,teachers)
> once I selected("public","datareader",and manually checked the insert and
> delete and update check box in front of the name above 3 tables).
> it granted permission as I expected to login1 but no table creation.
> how ca I add "creation" to my permission?
> any help would be thankful.
>|||R-M,
Try:
GRANT CREATE TABLE TO ...
See:
GRANT
http://msdn.microsoft.com/library/d...br />
8odw.asp
HTH
Jerry
<R> wrote in message news:opsyrxt6kgmw7tkz@.system109.parskhazar.net...
> Hi
> I'm working with SQL server 2000,and I want to grant one of my login to
> have following permission to DB1:
> login1 should be able to "create table",read from all tables in DB1 and
> insert and update and delete just for 3 tables(for example:
> customer,books,teachers)
> once I selected("public","datareader",and manually checked the insert and
> delete and update check box in front of the name above 3 tables).
> it granted permission as I expected to login1 but no table creation.
> how ca I add "creation" to my permission?
> any help would be thankful.