create database Auditlog
go
sqlcmd -S WIN-S8EDDIJHGA4\AUDITLOG -d AUDITLOG
select name from sys.databases;
create table members(
id int identity(1,1) primary key,
name nvarchar(32),
birthday datetime
);
select name from sysobjects where xtype = 'U'
create table SQLServerAuditLogs(
event_time datetime2,
action_id varchar(4),
action_name nvarchar(128),
succeeded bit
)
create user [jp1com] for login [WIN-S8EDDIJHGA4\jp1com]
create user [jp1apl] for login [WIN-S8EDDIJHGA4\jp1apl]
use master
grant control server to [WIN-S8EDDIJHGA4\jp1apl]
use auditlog
grant update to [jp1apl]
grant delete to [jp1apl]
grant references to [jp1apl]
grant connect to [jp1apl]
grant select to [jp1apl]
grant insert to [jp1apl]