Reakce na odpověď

Good point s kurzorem, avsak jeste bych Vas poprosil o radu. Pokud zakomentuji cast s pridavanim prav

GRANT SELECT, UPDATE, INSERT, DELETE ON @table_name TO [MASINA\LICusers]

, tak vse funguje v poradku a vypise to. Pokud ji vsem necham tak mi to pise nasledujici chybu:

Msg 102, Level 15, State 1, Line 18
Incorrect syntax near '@table_name'.
Msg 102, Level 15, State 1, Line 29
Incorrect syntax near '@table_name'

DECLARE @table_name varchar(50)

DECLARE Cursor_in_table CURSOR -- Declare cursor

LOCAL SCROLL STATIC

FOR

Select name from SYS.tables where name like 'IN%'

OPEN Cursor_in_table -- open the cursor granting privileges for IN tables

FETCH NEXT FROM Cursor_in_table

   INTO @table_name

   PRINT 'Granting privileges to the following table: '+ @table_name  -- print the name
	GRANT SELECT, UPDATE, INSERT, DELETE ON @table_name TO [MASINA\LICusers]

WHILE @@FETCH_STATUS = 0

BEGIN

   FETCH NEXT FROM Cursor_in_table

   INTO @table_name

   PRINT 'Granting privileges to the following table: '+ @table_name
	GRANT SELECT, UPDATE, INSERT, DELETE ON @table_name TO [MASINA\LICusers]

END
close Cursor_in_table

SQL dotaz navrh DB