Auditiranje kolone u tablici
USE [XX]
GO
CREATE DATABASE AUDIT SPECIFICATION [DatabaseAuditSpecification-20090812-100551]
FOR SERVER AUDIT [MAaudit]
ADD (DATABASE_OBJECT_ACCESS_GROUP),
ADD (DATABASE_OBJECT_PERMISSION_CHANGE_GROUP),
ADD (DATABASE_CHANGE_GROUP),
ADD (APPLICATION_ROLE_CHANGE_PASSWORD_GROUP),
ADD (SELECT ON [dbo].[Transakcija.Kartica] BY public),
ADD (DATABASE_OBJECT_OWNERSHIP_CHANGE_GROUP)
WITH (STATE = OFF)
GO
Greška:
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'Transakcija.Kartica', because it does not exist or you do not have permission.
Tablica transakcija sigurno sadrži kolonu kartica, ja imam sva moguća prava na toj bazi jer kad idem napravit selec on tablica audit onda mi prolazi... Gdje griješim?
 |  |
 |
