h1

Acordare permisiuni si retragere permisiuni alt user (clauzele GRANT SI DENY)

March 9, 2010

1) GRANT Database Principal Permissions (Transact-SQL)

Exemplul1:

Exemplul2 (Clauza GRANT pe Views-uri):


http://msdn.microsoft.com/en-us/library/ms173848.aspx

2) GRANT Assembly Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms189479.aspx

3) GRANT Asymmetric Key Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms187991.aspx

4) GRANT Certificate Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms186278.aspx

5) GRANT Service Broker Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms188798.aspx

6) GRANT Database Permissions (Transact-SQL)

7) GRANT Endpoint Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms187811.aspx

8 ) GRANT Full-Text Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms190502.aspx

9) GRANT Object Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms188371.aspx

10) GRANT Server Principal Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms178640.aspx

11) GRANT Schema Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms187940.aspx

12) GRANT Server Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms187940.aspx

13) GRANT Symmetric Key Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms179887.aspx

14)  GRANT System Object Permissions (Transact-SQL) (Granting SELECT permission on a view)

http://msdn.microsoft.com/en-us/library/ms187797.aspx

15) GRANT Type Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms174346.aspx

16)GRANT XML Schema Collection Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms179867.aspx

Clauza DENY

1) DENY Database Principal Permissions (Transact-SQL)

2) DENY Assembly Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms188402.aspx

3) DENY Asymmetric Key Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms189473.aspx

4) DENY Certificate Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms179876.aspx

5) DENY Service Broker Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms186291.aspx

6) DENY Database Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms177518.aspx

7) DENY Endpoint Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms177524.aspx

8) DENY Full-Text Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms189502.aspx

9) DENY Object Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms173724.aspx

10) DENY Server Principal Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms186710.aspx

11) DENY Schema Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms176128.aspx

12) DENY Server Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms182763.aspx

13) DENY Symmetric Key Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms178591.aspx

14) DENY System Object Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms178634.aspx

15) DENY Type Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms180063.aspx

16) DENY XML Schema Collection Permissions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms174419.aspx

Clauza REVOKE (Transact-SQL)Removes a previously granted or denied permission.

http://msdn.microsoft.com/en-us/library/ms187728.aspx

Clauza FETCH:

Retrieves a specific row from a Transact-SQL server cursor.

http://msdn.microsoft.com/en-us/library/ms180152.aspx

@@FETCH_STATUS (Transact-SQL)

Returns the status of the last cursor FETCH statement issued against any cursor currently opened by the connection.

http://msdn.microsoft.com/en-us/library/ms187308.aspx

CREATE CREDENTIAL :

http://msdn.microsoft.com/en-us/library/ms189522.aspx

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: