informix user grants

myu2050 · #1 (**permalink**) 11-01-02, 17:09

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

Thanks!

zathrus · #2 (**permalink**) 11-11-02, 15:08

dbschema -d <databasename> -ss -p <username or all or public>

tungaw2001 · #3 (**permalink**) 11-14-02, 04:01

Quote:

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech