[EMAIL PROTECTED] wrote:
> 
> Yes.I know this link.
> 
> But i find a resource user can access data,Definition of views, synonyms
> and temporary tables.Those are standard user's Properties.
> 

But perhaps you did not read them carefully:
As is written there:

The user classes are hierarchically ordered as follows:

・        The user class RESOURCE encompasses all the rights of STANDARD users.

・        The user class DBA encompasses all the rights of RESOURCES users.

・        The database system administrator (SYSDBA) can create DBA users. He 
or she has owner rights over all users. Otherwise, the SYSDBA has the same 
function and the same rights as a DBA user, that is, whenever a DBA user is 
allowed to execute an SQL statement, this also applies to a SYSDBA user.



In the table (can be found with the first link) the additional properties are 
listed.

Elke
SAP Labs Berlin


> >From: "Zabach, Elke" <[EMAIL PROTECTED]>
> >To: "? ?" <[EMAIL PROTECTED]>, <[email protected]>
> >Subject: AW: a question on differences in standard user and resource user
> >Date: Fri, 6 May 2005 13:02:27 +0200
> >
> >
> >
> > > -----Ursprüngliche Nachricht-----
> > > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > > Gesendet: Donnerstag, 5. Mai 2005 05:01
> > > An: [email protected]
> > > Betreff: a question on differences in standard user and resource user
> > >
> > > I know a standard-user can't doing any resource-user operators.
> > > But maybe resource-user can do all standard-user operators,don't it?
> > >
> >
> >Please follow these links and you will find the answers for the questions
> about user-rights:
> >
> >http://dev.mysql.com/doc/maxdb/en/4f/ac35406ee32e34e10000000a155106/frame
> set.htm
> 
> >http://dev.mysql.com/doc/maxdb/en/48/f0daa5225811d3a97d00a0c9449261/frame
> set.htm
> 
> >
> >Elke
> >SAP Labs Berlin
> >
> > > thanks!
> > >
> > > _________________________________________________________________
> > > 享用世界上最大的电子邮件系统― MSN Hotmail。  http://www.hotmail.com
> > >
> > >
> > > --
> > > MaxDB Discussion Mailing List
> > > For list archives: http://lists.mysql.com/maxdb
> > > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> >--
> >MaxDB Discussion Mailing List
> >For list archives: http://lists.mysql.com/maxdb
> >To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
> 
> _________________________________________________________________
> 与联机的朋友进行交流,请使用 MSN Messenger:  http://messenger.msn.com/cn

Reply via email to