It seems often we are working with the accounts provided by the Oracle database during installation we can change username and password . When we do our table creation we usually use the account named as 'System' or 'Manager' which is having all the privileges which are required to work with the project.
It contains many tables and sachems as default which mix-ups with our newly created. So, here what i am going to demonstrate that how we can create a separate user for separate projects.
Open sql commnad prompt->Connect to 'System' Account as given in figure with your password or username in case you have different admin account.
Use the following commands to create a user , in our example larningmart is user name and password.
Now, providing permission to the newly created user to create,delete,update etc.
Disconnect from System account and login to your newly created learningmart account
All done , create your tables now for your projects. enjoy !!
It contains many tables and sachems as default which mix-ups with our newly created. So, here what i am going to demonstrate that how we can create a separate user for separate projects.
Open sql commnad prompt->Connect to 'System' Account as given in figure with your password or username in case you have different admin account.
Use the following commands to create a user , in our example larningmart is user name and password.
Now, providing permission to the newly created user to create,delete,update etc.
Disconnect from System account and login to your newly created learningmart account
0 comments:
Post a Comment