Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    2

    Lightbulb Unanswered: informix user grants

    I'd like to have scripts which will show all the privileges grant to a user. Any idea?


    Thanks!

  2. #2
    Join Date
    Oct 2002
    Posts
    6
    dbschema -d <databasename> -ss -p <username or all or public>

  3. #3
    Join Date
    Nov 2002
    Posts
    25

    Re: informix user grants

    Originally posted by myu2050
    I'd like to have scripts which will show all the privileges grant to a user. Any idea?


    Thanks!
    use $dbschema -d "databasename" -p "all" file.txt

    view the file and you'll see all the previliges for all users.
    Just change the "all" to specific user if you want specific.

Posting Permissions

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