REVOKE command in SQL is used to remove one or more privileges assigned to a database user. The basic syntax for REVOKE command is given below. REVOKE priv_type [(col_list)] [, priv_type [(col_list)]]… ON [obj_typ] priv_level FROM user [, user_name] The list of privileges that need to be revoked is mentioned right after the REVOKE statement. […]
SQL GRANT Command
GRANT command in SQL is used grant one or more privileges to a database user. The basic syntax for GRANT statement in a SQL is given below. GRANT privilege_name ON object_name TO {user_name |PUBLIC |role_name} [WITH GRANT OPTION]; privilege_name: is the privilege provided to the user. The access right for a user includes ALL, SELECT […]
All about SQL CREATE USER Query
The CREATE USER statement allows us to create a new user account in the SQL database. Almost all the database platforms provide GUI to create new users. However CREATE USER statement is a standard in SQL and basic syntax for creating user in SQL is given below, CREATE USER username [IDENTIFIED BY password] [other options]; […]
MySQL Transaction
First MySQL version to support transaction is 3.23.0. The transaction support to MySQL is done using new storage engines. The storage engines which support transactions were named as InnoDB and Berkeley DB. New storage engines were added in the MySQL to improve the compatibility of transaction. Improving the transaction compatibility will result in smooth transactions […]
How to Tune SQL Queries
Tuning the SQL queries will result in positive impact on the performance of database. What is Query Execution Plan? Query execution plan can be defined as the list which contains the details of a particular process done by the RDBMS. This plan contains the details about indexes and joins processed by the SQL query. The […]
How to Prevent SQL Injection?
SQL injection attack is a threat to even the most secured database in the world. Even the most secure database of CIA, Citi bank, MI6 were subjected to SQL attack. This article will guide through the steps to prevent your databases from basic SQL injection attacks. Read: More Interview Questions Input Sanitization The basic step […]
SQL: Full database Table Scan
Full table scan in a database can be defined as the process of scanning all the rows present in the table. Full table scan in database is very slow when compared to the normal database scan. Using indexes in database can replace the use of full table scan. The following scenarios will force the full […]
- « Previous Page
- 1
- …
- 4
- 5
- 6
- 7
- 8
- …
- 13
- Next Page »