Createing several users with objects from script 
Author Message
 Createing several users with objects from script

Hi all,
I want to create several users and objects and grants for each of them. I
also need to insert initial data into some of the objects.
The script will be run logged on as a "superuser" with the privs needed.

What I am thinking is:
- create user a identified by xxxx
- create user b identified by yyyy
- grant connect +++ to a,b

- connect a/xxxx
- create tables, indexes, RI, views
- insert initial data into objects
- grant insert on objects to role

- connect b/yyyy
.....

Are there better ways?

AJ



Tue, 05 Aug 2003 16:17:14 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. any body has a script to script users permissions on db objects

2. Createing a user + more

3. How do you script all object of a database to a script file

4. converting paradox dos script to paradox (object pal) windows script

5. Dependent objects script is empty although many dependent objects exist

6. Creating several functions in the same script

7. How execute several operations in a unique script

8. Script Newbi - how to you ask user in a script

9. Manage permission on several objects

10. Restore just several objects from a backup

11. Pg module and several result objects

12. several datacombo objects in a frontend


 
Powered by phpBB® Forum Software