Results 1 to 5 of 5

Thread: How to grant permission?

  1. #1
    Join Date
    Nov 2009
    Posts
    1,118

    How to grant permission?

    Hi All,

    I ma developing project in the SQL. For this project I need to grant permission for different user with different access rights . I don't know the procedure to grant the permission in the SQL.
    Please let me aware about the How to grant permission? I would greatly appreciate your any help over this.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,949

    Re: How to grant permission?

    Hi Friend,

    In the SQl you can achieve the granting by using the "GRANT" command. The syntax for the "GRANT" command is as below:
    GRANT <permissions which you want apply>
    [ON <name of the table over you want to apply permission>]
    Example:
    GRANT <READ>
    [ON <EMP>]

  3. #3
    Join Date
    May 2008
    Posts
    2,015

    Re: How to grant permission?

    Hello,

    Please refer below syntax for the granting any permission in the SQL:
    GRANT
    {
    ALL [PRIVILEGEStype] | permission}
    {
    [(columnName)] ON {tableName | viewName}
    | ON {tableName | viewName}[(columnName)]
    | ON {stored_procedureName | extended_procedureName}
    }
    TO securityAccountName
    [WITH GRANT OPTION]
    [AS {groupName}]

  4. #4
    Join Date
    Apr 2008
    Posts
    2,010

    Re: How to grant permission?

    If you want to gran the permission over the SQL statement. You can grant permission for following statement:
    1. BACKUP DATABASE statement
    2. CREATE TABLE statement
    3. CREATE DATABASE statement
    4. CREATE DEFAULT statement
    5. CREATE RULE statement
    6. CREATE VIEW statement
    7. BACKUP LOG statement
    8. CREATE PROCEDURE statement

  5. #5
    Join Date
    May 2008
    Posts
    2,302

    Re: How to grant permission?

    Hi friend,
    The below SQL example will demonstrate yow procedure to grant permission in SQL:
    GRANT insert

    ON account

    TO public

    GO


    GRANT delete, insert

    ON account

    TO adam, lana

    GO

Similar Threads

  1. Replies: 3
    Last Post: 07-01-2014, 08:48 AM
  2. The Sims 3 Showtime: Genie won't Grant wishes
    By Raj@LOL in forum Video Games
    Replies: 7
    Last Post: 15-03-2012, 11:20 PM
  3. Replies: 3
    Last Post: 20-03-2011, 05:40 AM
  4. Syntax for GRANT and REVOKE in MySQL
    By MacKenze in forum Software Development
    Replies: 4
    Last Post: 09-12-2010, 03:38 AM
  5. I can't grant terminal access to users in GPO
    By troy in forum Active Directory
    Replies: 3
    Last Post: 05-04-2007, 09:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •