[ opti2k4 @ 03.09.2009. 13:55 ] @
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?





[ Zidar @ 03.09.2009. 14:33 ] @
To sto ti radi SELECT ne znaci da imas 'sva moguca prava'. Ako server kaze you do not have permission' onda zanci da ti nedostaje neki permission. Proveri sa administratorom baze sta imas a sta nemas.
[ opti2k4 @ 03.09.2009. 15:02 ] @
Probao i sa:

SELECT ON [dbo].[Transakcija].[Kartica] BY public

Rezultat:

Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'Kartica', because it does not exist or you do not have permission.




Btw ja sam admin , na serveru i na bazi imam sve moguće permissione.
[ opti2k4 @ 04.09.2009. 09:17 ] @
Čisto za info, nije moguće auditirat kolonu, jedino tablicu. Ispod toga audit ne ide.