MSSQL Tutorial User Role 60 codes

  1. Home
  2. MSSQL Tutorial
  3. User Role
1 A GRANT statement that grants permission to execute a stored procedure
2 A GRANT statement that grants permission to run action queries
3 A GRANT statement that grants SELECT permission to specific columns
4 A REVOKE statement that revokes all permissions for the Bankers table
5 A REVOKE statement that revokes permission to create databases and tables
6 A REVOKE statement that revokes SELECT permission
7 A REVOKE statement that revokes the DELETE permission
8 All permissions applicable to the specified securable will be granted to the specified principal
9 Altering a SQL Server Login
10 Altering a Windows Login
11 Change the default schema for user Fred
12 Check user id with user_id() function
13 Create a new schema
14 Create a proxy login from the certificate
15 Create a proxy user
16 Create a proxy user and grant access to the schema
17 Create a user and a table, and make the user own the table
18 Create a user and a table, and make the user the owner of the table
19 Creates a new Windows login and then maps that login to a new database user
20 Creating a certificate and an asymmetric key
21 Creating a certificate in the master database
22 Creating a SQL Server Login
23 Creating a Windows Login
24 Creating Database Users with schema
25 DENY Statement
26 Denying SQL Server Access to a Windows User or Group
27 DROP LOGIN
28 Dropping a SQL Login
29 Dropping a Windows Login
30 Example of GRANT EXEC Statement
31 GRANT CREATE FUNCTION TO mary
32 GRANT CREATE TABLE, CREATE PROCEDURE TO peter, paul, mary
33 Granting Permission on a Column in a View
34 Managing Application Roles
35 Managing Fixed Database Role Membership
36 Managing Server Role Members
37 Managing User-Defined Database Roles
38 Modifying a Database User for name
39 Modifying a Database User for the schema
40 Move tables between schemas
41 Reference the schema in a query
42 Removing a Database User from the Database
43 Reporting Fixed Database Roles Information
44 Reporting Fixed Server Role Information
45 REVOKE permissions
46 REVOKE Statement
47 Select CURRENT_USER
48 Select USER
49 Some of the SQL Server fixed server roles
50 The DENY statement is used to explicitly prohibit a user or role members from performing a specific action on an object
51 The use of the CONTROL permission
52 The use of the CREATE SCHEMA statement
53 The use of the SELECT permission within the GRANT statement
54 The use of the UPDATE permission within the GRANT statement
55 The use of the VIEW DEFINITION permission
56 The use of the WITH GRANT OPTION clause of the GRANT statement
57 To grant permission is to give or allow permission to perform a type of operation on an object
58 USER_NAME Function returns the name of user logged into the database The syntax for the USER_NAME function is as follows
59 Viewing SQL Server Logins
60 Viewing Windows Logins