| Subject | RE: [firebird-support] Create SYSDBA power under a different name and then delete SYSDBA |
|---|---|
| Author | Goutam Paruchuri |
| Post date | 2004-12-20T14:30:54Z |
Multiple users could belong to a single role.
You can assign permissions to role and don't have to individually assign
the same permissions to all the users within the role.
Eg. You have users x,y,z. You need the users to have same level of
permissions all the time.
Create a role p , assign x,y,z to Role p . Grant the permission to Role
p.
- Goutam
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.
You can assign permissions to role and don't have to individually assign
the same permissions to all the users within the role.
Eg. You have users x,y,z. You need the users to have same level of
permissions all the time.
Create a role p , assign x,y,z to Role p . Grant the permission to Role
p.
- Goutam
> -----Original Message-----Confidentiality Notice
> From: vso_ad1@... [mailto:vso_ad1@...] On
> Behalf Of Namit Nathwani
> Sent: Monday, December 20, 2004 7:41 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Create SYSDBA power under a
> different name and then delete SYSDBA
>
>
>
> Hi Ivan
>
> At 05:16 pm 20/12/2004, you wrote:
> >You mean how to create database ? Using Create Database command.
>
> No, no that much I have accomplished and have also been
> programming for the database.
>
> >CREATE ROLE SYSDBA;
>
> Okay thanks, but what's the diff. between roles and users?
>
> Is SYSBDA a role or a user by default?
>
> When I create a user using IBEasy+ am I creating just that or
> am I creating a role?
>
> and so on ... <g>
>
>
>
>
> Regards
> Bhavbhuti
> ___________________________________________
> Softwares for Indian Businesses at:
> http://ahmedabad.sancharnet.in/vso_ad1/
> namitbn@...
> ___________________________________________
>
> ----------
>
>
>
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 17/12/2004
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> $4.98 domain names from Yahoo!. Register anything.
> http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.