I am to IBM Data Studio. I am using the Full Windows Client. I am have a problem understanding how to set up a User for a database. I am following the Getting Started Guide. I am creating the plan according to the Guide. However, I don't have the permissions to run the plan.
What kind of permissions are necessary to create database groups and users? All of the commands in the plan are failing. Would someone help me get to Square One on this? I really could use your help. Links to any resources would be helpful, too.
freda521 2700058T4N5 Posts
Re: Help With Creating DB2 Groups and Users2012-08-29T05:41:29ZThis is the accepted answer. This is the accepted answer.That because the connection user haven't DBADM permissions.
A) If you just want to create a new user,the easiest method is use another user who already have DBADM credential to connect the database and create the user.(The default user is your system administator)
B) If you want to grant a new user have DBADM permission,you should do as below:
1. If you under windows system,create a new user USER1 in DB2ADMNS user group.
2. Open Data Studio, use admin user(already have DBADM credential) to connection the database and create a new user named USER1.
3. Alter the privileges of USER1,grant the DBADM permission to it,deploy the change.
4. Use USER1 to connect the database,now the USER1 have create user permission.
PS:You will never really create a user or a group because they are only created at OS level.In Data Studio GUI you only give/assign them individual rights.
Re: Help With Creating DB2 Groups and Users2012-09-03T15:37:39ZThis is the accepted answer. This is the accepted answer.
- freda521 2700058T4N
BTW, I am using Windows 7 Professional.
Thanks for that info. I had read that in the DB2 Data Studio PDF. I went through the PDF an created a plan to assign rights to that user. However, the created plans fail.
I have tried to clean by reinstalling DB@ however, I have run in to another error: Error 5 running command
.\EXPC\image\setup.exe. I don't know how to resolve this problem either. I have posted a question to this forum.
Any help that you can give me would be greatly appreciated.
freda521 2700058T4N5 Posts
Re: Help With Creating DB2 Groups and Users2012-09-05T08:44:01ZThis is the accepted answer. This is the accepted answer.What is the sql exception of your failed change plan?
And what the ".\EXPC\image\setup.exe" is?
Is the db2 install failed or data studio?
Could you give me more information.
bluey01 110000ENQX41 Posts
Re: Help With Creating DB2 Groups and Users2012-09-06T08:01:31ZThis is the accepted answer. This is the accepted answer.
As a general question - how is the DS Web Console supposed to work for different users. For example -I can set myself up as DBADM, setup a repository database and it all works as expected. I can looat at several databases and see active connections and so on.
Now I want to let a developer monitor one of the databases they are using. So I can set them up in the repository as a DSWC user inder an appropriate group. However, it looks like for them to monitor a databases, then have to be setup in the database as a DBADM privilege?
Is this correct - if so, then what is the point - as they are a developer - they should not have DBADM access to a database. So how do they monitor their connections and see what is happenning?
YuanFeng 2700030G5D80 Posts
Re: Help With Creating DB2 Groups and Users2012-09-10T02:32:02ZThis is the accepted answer. This is the accepted answer.
- YuanFeng 2700030G5D
In any event, I prefer it in the same account as I have Rational Application Developer SE installed as well as my Outlook Email. I have a licensed copy. I am a J2EE Developer and RAD is my favorite Development environment. I am using these tools to learn new J2EE Frameworks, etc.
Thanks for your suggestion.