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;
No responses yet