Re: Roles -- do Sybase and Informix have a similar implementation?

In article <gagnon.6.000D80B2_at_heron.dsr.com>, gagnon_at_heron.dsr.com (Lorrie Gagnon) writes:
|>
|> I am currently designing a database where the application needs to have a
|> set of permissions for a user. I would like to be able to use the Oracle 7
|> roles to do this. However, there is the chance that the application will need
|> to be ported to Sybase and Informix. Can anyone comment on whether
|> those DBMSs have support for roles, and if so, how close it is to what
|> Oracle has?
|>
|> Thanks for your help,
|>

I have not yet worked with Oracle 7, so I don't know about Oracle Roles. However, we also use Sybase and it has always supported roles -- Sybase refers to them as groups. User groups are created in each database and then privileges are granted to the group on database objects. Then, any users added to that group acquire all privileges granted to that group. Groups with the same name, but in two different databases, are separate groups -- treated like they have different names by the RDBMS. Basically, the steps in adding users in Sybase are:

1. Create a login account on the SQL Server
2. Add the user to the database(s) they need access to
3. Add the user to the group in each database (optional)

Hope this helps.

                                Teresa Larson

+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
| Teresa A. Larson - Hughes STX Corporation                            |
| NASA/GSFC Code 933.0                        voice:  (301) 286-7867   |
| Greenbelt, Maryland  20771                  fax:    (301) 286-1777   |
| Teresa.Larson_at_gsfc.nasa.gov                                          |
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+