Remove a Role or person from Role ?

SpookiePower

Delphi Developer

Thu, 14 Apr 2005 20:19:07 GMT

Remove a Role or person from Role ?

Hi.

I'm using interbase 6.0 but I follow the 5.0 tutorial.
How can I delete a Role ? I have tryed to write "Drop SALESPEOPLE"
like when you drop a table, but i does not work. And how do I remove
a person from a Role ?

Thanks. Kim "SpookePower".

Martijn Tonie

Delphi Developer

Thu, 14 Apr 2005 20:57:50 GMT

Re:Remove a Role or person from Role ?

According to the documentation, you can remove roles for certain
users with REVOKE <role> FROM <user>

Or simply use InterBase Workbench and start the Role Editor :)

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

Quote

"SpookiePower" <bo 2...@hotmail.com> wrote in message

news:3dbbd9c5@newsgroups.borland.com...

Quote

> Hi.

> I'm using interbase 6.0 but I follow the 5.0 tutorial.
> How can I delete a Role ? I have tryed to write "Drop SALESPEOPLE"
> like when you drop a table, but i does not work. And how do I remove
> a person from a Role ?

> Thanks. Kim "SpookePower".

Thomas Steinmaure

Delphi Developer

Thu, 14 Apr 2005 20:45:31 GMT

Re:Remove a Role or person from Role ?

"SpookiePower" <boxjunk2...@hotmail.com> schrieb im Newsbeitrag news:3dbbd9c5@newsgroups.borland.com...

Quote

> Hi.

> I'm using interbase 6.0 but I follow the 5.0 tutorial.
> How can I delete a Role ? I have tryed to write "Drop SALESPEOPLE"
> like when you drop a table, but i does not work.

Do you get any error message?