2,209
社区成员
发帖
与我相关
我的任务
分享怎样在interbase建立用户(一定散分)
现想在通过编程实现：
通过用户sysdba 密码masterkey进入一个interbase 数据库
想通过编程方式再增建一个用户名.敬请高手指点。一定散分
通过用户sysdba 密码masterkey进入一个interbase 数据库
想通过编程方式再增建一个用户名.敬请高手指点。一定散分
...全文
请发表友善的回复…
发表回复
novo 2003-05-01
- 打赏
- 举报
hehe
up
up
TR@SOE 2003-05-01
- 打赏
- 举报
调用TIBSecurityService的AddUser方法，并设置好对应的参数即可。
hamzsy 2003-04-30
- 打赏
- 举报
IBConsole或者IBADMIN
paul911 2003-04-16
- 打赏
- 举报
In the previous section,you opened Server Manager and connected to a server as an existing user.
Now you create a new user, TUTOR. Note InterBase ships by default with one user, SYSDBA, defined.
1. In Server Manager, choose Tasks | User Security to display the InterBase Security dialog or click
the User Security button.
3. Type TUTOR in the User Name field and tutor4ib in the Password and Confirm Password
fields.
4. Click OK to close the User Configuration dialog. Click OK to close the InterBase Security
dialog.
You have now created a user on the server you’re logged into. Users are defined server-wide and
can connect to any database that resides on that server. Tables within these databases have
additional security, however. Being able to connect to a database won’t do you much good if you
don’t have privileges on any of its tables.
5. Now choose File | Exit. Choose Yes when InterBase asks you if you want to log out from all
servers and exit Server Manager.
Now you create a new user, TUTOR. Note InterBase ships by default with one user, SYSDBA, defined.
1. In Server Manager, choose Tasks | User Security to display the InterBase Security dialog or click
the User Security button.
3. Type TUTOR in the User Name field and tutor4ib in the Password and Confirm Password
fields.
4. Click OK to close the User Configuration dialog. Click OK to close the InterBase Security
dialog.
You have now created a user on the server you’re logged into. Users are defined server-wide and
can connect to any database that resides on that server. Tables within these databases have
additional security, however. Being able to connect to a database won’t do you much good if you
don’t have privileges on any of its tables.
5. Now choose File | Exit. Choose Yes when InterBase asks you if you want to log out from all
servers and exit Server Manager.
猛禽 2003-02-19
- 打赏
- 举报
用IBAdmin控件,DELPHI自带
erickleung 2003-02-18
- 打赏
- 举报
需视乎你是用那个工具.
ibx 有 TibsecurityService, (interbase Admin)
例子在:
D:\Borland\Delphi7\Demos\Db\IBX\Admin
ibx 有 TibsecurityService, (interbase Admin)
例子在:
D:\Borland\Delphi7\Demos\Db\IBX\Admin
回炉重造，学习编程中。。。 2003-02-18
- 打赏
- 举报
对数据库不熟，帮你up
CuteBit 2003-02-18
- 打赏
- 举报
当然，你也可以连接到 isc4.gdb 后直接对 users 表操作，但这样似乎不够规范 :)
CuteBit 2003-02-18
- 打赏
- 举报
在命令行使用 gsec -user sysdba -password masterkey 命令进入 gsec ，在 gsec 里使用 add 加入用户；delete 删除用户；modiy 修改用户等。
使用 DSQL 的授权语句对用户授权。
使用 DSQL 的授权语句对用户授权。
linx2 2003-02-18
- 打赏
- 举报
编程方式？不会。学习一下～帮你顶！！！
