Re: ROLES OR GROUPS WHILE ASSIGNING PRIVILEGE
basically you need to:
Import db/securich.sql in order to create the `securich` database with all it's tables
Import all procedures in procedures thus creating all stored procedures necessary
Import db/data.sql populating the "privileges, roles (read and write roles), databases, tables, stored procedures" tables
importing any of the above is done:
mysql -u root -p --socket=/tmp/mysql.sock < "filetoimport.sql" where filetoimport.sql is the name of the file you need to import ie db/securich.sql for example.
Then create the roles using `call create_update_role('rolename','privilegetype');
Subject
Views
Written By
Posted
6181
February 14, 2007 08:28AM
3317
June 15, 2009 07:16AM
3079
June 15, 2009 08:31AM
3140
June 15, 2009 08:45AM
3158
June 15, 2009 08:51AM
Re: ROLES OR GROUPS WHILE ASSIGNING PRIVILEGE
4085
June 15, 2009 09:49AM
3900
February 17, 2007 06:53AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.