Results 1 to 6 of 6

Thread: Grant

  1. #1
    Junior Member
    Join Date
    Feb 2007
    Answers
    10

    Grant

    Hi,

    How can we grant full permissions to user on any database in sql?
    Regards,
    Radhi.


  2. #2
    Junior Member
    Join Date
    Feb 2007
    Answers
    8
    hi ridhi,
    i think u should try this......

    GRANT permission, ...
    TO userid, ...

    permission :
    DBA
    | BACKUP
    | VALIDATE
    | GROUP
    | MEMBERSHIP IN GROUP userid, ...
    | [ RESOURCE | ALL ]

    i m not much sure that will this solves ur problem or not........


    is ur problem solved???????????

    Last edited by kalayama; 02-22-2007 at 08:03 AM. Reason: Be patient; Don't post too many posts without any replies to your previous post

  3. #3
    Junior Member
    Join Date
    Feb 2007
    Answers
    10

    Re: Grant

    Hi Shivender,

    ya i rather got it solved.
    I used roles to do it.
    thanks for the concern

    Regards,
    Radhi.


  4. #4
    Junior Member
    Join Date
    Jan 2008
    Answers
    24

    Re: Grant

    There are 3 types of roles to grant privileges depending upon requirement
    1.Resource
    2.Connect
    3.DBA

    Among these DBA cotains all the privileges,try the following one


    sql> Grant DBA to ;


  5. #5

    Re: Grant

    login as sys, system
    grant sysdba to user


  6. #6
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Grant

    You may not grant SYSDBA from system schema. Better to login as SYS instead.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact