If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

That would drop the user but i want to revoke all the rights of a user .
i tried with REVOKE ALL FROM <USER> but that only removes the execute permissions on commands like (Create Database, Create Default, Create Procedure, Create Rule , Create Table , Create View) .

It doesnot remove the object permissions ie permissions on various table/ views .

IMHO:
- you can do this with a script, that makes a SELECT on data dictionary to obtain all the privileges that user has and then execute REVOKEs for that privileges
- an easier solution is to drop the user and re-create it again.

But:
- a user can be part of a group (and that group has its own privileges)
- some privileges are granted to PUBLIC (so your user will have those too)
- the login can be part of a role (and that role may have some privileges too)

Well, that's another problem. Sybase documentationSyBooks Online
says:
You cannot drop a user who owns objects in the database.
You cannot drop a user who has granted permissions to other users.
You cannot drop the Database Owner from a database.