Discussion Locked

Oracle designer queries

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

HOw to create priviliges to
1. Create new user

2. Create public synonym

3. Create role.

2. After creating priviliges to the above, how to create
a new user, a public synonym, and a role?

3. In repository I went to priviliges and checked the
available priviliges there the create user privilige was not
there. and there is INTO mark across create public synonym and grant
role. So what is the command to turn that into marks to tick
marks?

3 replies

by rapidad

probably the easiest is to load the DBA Studio 8i(8.1.6/7) or Enterprise Manager 9i and do these chores against the instance. These are contained on the oracle cd as client or full server install. Oracle 805, 616/7,9i are available as free downloadsfrom the OTN oracle technical network (you just have to join, which is free). If you are looking to find the command line for those chores they are in the readme docs after you download.

This discussion is closed to new replies.