Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Post Unanswered: Create a user with only select priveleges

    How to create a user with only select priveleges? Or how to revoke priveleges of update, delete and insert from all tables on a quick way?
    Imagine that you have a system with 3000 tables ...

    Hope someone may help.
    Thank you in advance,

    MPpt

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: Create a user with only select priveleges

    Originally posted by mppt
    How to create a user with only select priveleges? Or how to revoke priveleges of update, delete and insert from all tables on a quick way?
    Imagine that you have a system with 3000 tables ...

    Hope someone may help.
    Thank you in advance,

    MPpt
    Hi there,


    Revoke all on tablename from public;
    Grant connect to user;
    Grant select, insert, update, delete on tablename to user;


    Regards,

    lloyd

  3. #3
    Join Date
    Oct 2003
    Posts
    2

    Exclamation Re: Create a user with only select priveleges

    Hi lloyd,

    I thank you for your help. However my problem is that I do not wish to grant or revoke priveleges table by table. Is there anyway to revoke or grant priveleges to all tables at once?

    Regards,

    MPpt

    Originally posted by lloydnwo
    Hi there,


    Revoke all on tablename from public;
    Grant connect to user;
    Grant select, insert, update, delete on tablename to user;


    Regards,

    lloyd

Posting Permissions

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