Wählen Sie Ihren SQL-Server:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Neuheiten abonnieren
Partners
Testimonials
Qian Dong: "Although I evaluated Oracle Maestro for only a couple of days, I must say I like what I saw in this product. I am going to place an order for this product.

Thank you for the good work".
Laurits Sogaard Nielsen: "Oracle Maestro (and also MS SQL Maestro) are the perfect substitutes for TOAD and in some ways also much better products (they are much cheaper, and the support is fast and easy). I'm looking forward to getting much more experience with both products, that already now have proven themselves to be fantastic".

More

Add your opinion

Oracle Maestro online help

Prev Return to chapter overview Next

Specifying role option

Specify role options according to your needs. The detailed description is given below.

 

Name

The field contains new role name as it was set on the previous step.

 

Identity type (By password, Externally, Globally, Using package, Not identified)

The role option indicates the specified method a user must be authorized by.

The By password clause lets you create a local role and indicates that the user must specify the password to the database when enabling the role. The password can contain only single-byte characters from your database character set regardless of whether this character set also contains multibyte characters.
Specify Externally to create an external role. An external user must be authorized by an external service, such as an operating system or third-party service, before enabling the role.
Specify Globally to create a global role. A global user must be authorized to use the role by the enterprise directory service before the role is enabled, or at login.
The Using package clause lets you create an application role, which is a role that can be enabled only by applications using an authorized package.
Specify Not identified to indicate that this role is authorized by the database and that no password is required to enable the role.

 

Package name

Set the package for Using package roles. If you do not specify schema, then the database assumes the package is in your own schema.

 

Password

Specifies the password that database users will use to activate the role.



Prev Return to chapter overview Next