SQL server

1.A new database

2.A new table

2.1 in properties choose is identity yes

3.A New user

4. Settel Restrictions

USE Targv22; 
GRANT CREATE TABLE,ALTER TO pavelivanov; 
Go

4.2 Check if we can create table

CREATE TABLE logi3( 

logiid int PRIMARY KEY IDENTITY(1,1),

 kuupaev datetime, 

andmed text);

4.3Check if we can not drop the table

DROP TABLE logi3;