Welcome to Sign in | Help

Re: generare script SQL 2000 grant permissions

  •  05-07-2008, 2:07 PM

    Re: generare script SQL 2000 grant permissions

    Foloseşte SQL Server Management Studio [Express]: din meniul contextual al bazei de date ...

    şi selectezi opţiunea "Script object level permision" -> True !

    Exemplu script generat:
    ...
    DENY DELETE ON [dbo].[Factura] TO [username]
    GO
    DENY INSERT ON [dbo].[Factura] TO [username]
    GO
    DENY UPDATE ON [dbo].[Factura] TO [username]
    GO
    GRANT SELECT ON [dbo].[Factura] TO [username]
    GO

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems