Subject | How to restrict a user from creating a database or adding tables? |
---|---|
Author | Phil Couling |
Post date | 2009-01-29T06:10:15Z |
Hi
I'd like to restrict the access of some users to only a very small set
of operations.(namely selecting from a handful of procedures).
When I create a user using the gsec tool, the new user is given enough
access to both create a new database and create tables within existing
databases. While this could not be used to do anything other than fill
up my hard drive, it's something that I'd like to restrict a user from
doing.
However after spending hours on google I'm still no closer to my goal.
Any suggestions?
Thanks
I'd like to restrict the access of some users to only a very small set
of operations.(namely selecting from a handful of procedures).
When I create a user using the gsec tool, the new user is given enough
access to both create a new database and create tables within existing
databases. While this could not be used to do anything other than fill
up my hard drive, it's something that I'd like to restrict a user from
doing.
However after spending hours on google I'm still no closer to my goal.
Any suggestions?
Thanks