How to give Privilege for Table using SQL Server

The account with Administrator privilege can only provide privileges for table in two manners,
  1. GRANT
  2. REVOKE

SQL GRANT Command

SQL GRANT is a command used to provide access or privileges on the database objects to the users.

SYNTAX:
GRANT privilege_name
ON object_name
TO {user_name |PUBLIC |role_name}
[WITH GRANT OPTION];

privilege_name is the access right or privilege granted to the user. Some of the access rights are ALL, EXECUTE, and SELECT.
object_name is the name of an database object like TABLE, VIEW, STORED PROC and SEQUENCE.
user_name is the name of the user to whom an access right is being granted.
user_name is the name of the user to whom an access right is being granted.
PUBLIC is used to grant access rights to all users.
ROLES are a set of privileges grouped together.
WITH GRANT OPTION - allows a user to grant access rights to other users.

SQL REVOKE Command:

The REVOKE command removes user access rights or privileges to the database objects.

SYNTAX

REVOKE privilege_name
ON object_name
FROM {user_name |PUBLIC |role_name}

Sending Group Mail via SMTP in PHP

This tutorial will you to send Email via SMTP using PHP coding. First we have to declare and assign the value for variables like First Name, Last Name, Email id to whom we need to send the email

SMTPmail

Image Cropping using JQuery & PHP Coding

Today we are going to see how to crop the Image as we need using JQuery in PHP and we are going to store that cropped image in MySql database.

Here is the sample Screen Shot

cropimage

Create the MySql database with needed information like user id, username, password, email, profile image, profile image small for cropped image.