sybase12。5 不能增加段，不能把用戶加到public里面

whiterain

use MCPDB
go
sp_addsegment seg_mcpdata,MCPDB,mcpdata1
go－－執(zhí)行成功
sp_addsegment seg_mcplog,MCPDB,mcplog1
go －－錯誤
報告如下錯誤：
1> use MCPDB
2> go
1> sp_addsegment seg_mcplog,MCPDB,mcplog1
2> go
Msg 17283, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_addsegment', Line 139:
'mcplog1' is reserved exclusively as a log device.
(return status = 1)
1>

不能在pulic用戶組下面增加用戶：錯誤如下：
1> use MCPDB
2> go
1> sp_dropgroup public
2> go
Msg 156, Level 15, State 1:
Server 'SYBASE', Line 1:
Incorrect syntax near the keyword 'public'.
1> sp_addgroup public
go2>
Msg 156, Level 15, State 1:
Server 'SYBASE', Line 1:
Incorrect syntax near the keyword 'public'.
1> use MCPDB
2> go
1> sp_dropuser mcpuser
2> go
Msg 17232, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_dropuser', Line 156:
No user with the specified name exists in the current database.
(return status = 1)
1> sp_adduser  mcpuser,mcpuser,public
2> go
Msg 156, Level 15, State 1:
Server 'SYBASE', Line 1:
Incorrect syntax near the keyword 'public'.

謝謝各位，幫忙看看、

chenfeng825

原帖由 whiterain 于 2007-7-10 09:47 發(fā)表
use MCPDB
go
sp_addsegment seg_mcpdata,MCPDB,mcpdata1
go－－執(zhí)行成功
sp_addsegment seg_mcplog,MCPDB,mcplog1
go －－錯誤
報告如下錯誤：
1> use MCPDB
2> go
1> sp_addsegment seg_mcplog,MCPD ...

A1
1> create database a on a='10M' log on b='10M'
2> go
CREATE DATABASE: allocating 2560 logical pages (10.0 megabytes) on disk 'a'.
CREATE DATABASE: allocating 2560 logical pages (10.0 megabytes) on disk 'b'.
1> alter database a log on c='10M'
2> go
Extending database by 2560 pages (10.0 megabytes) on disk c
Warning: Using ALTER DATABASE to extend the log segment will cause user thresholds on the log segment within 128 pages of
the last chance threshold to be disabled.
1> use a
2> go
1> sp_addsegment c,a,c
2> go
Msg 17283, Level 16, State 1:
Server 'DB01', Procedure 'sp_addsegment', Line 149: 'c' is reserved exclusively as a log device.


A2
1> sp_helpuser
2> go
Users_name        ID_in_db    Group_name        Login_name
----------------- ----------- ----------------- -----------------
dbo                         1 public            sa
(return status = 0)
1> sp_addlogin test_user,'123456',a
2> go
Password correctly set.
Account unlocked.
New login created.
(return status = 0)
1> sp_adduser test_user
2> go
New user added.
(return status = 0)
1> sp_helpuser
2> go
Users_name        ID_in_db    Group_name        Login_name
----------------- ----------- ----------------- -----------------
dbo                         1 public            sa
test_user                   3 public            test_user

1> sp_dropuser public
2> go
1> sp_adduser test_user,test_user,public
2> go
Msg 156, Level 15, State 2:
Server 'DB01', Line 1:Incorrect syntax near the keyword 'public'.
1> sp_adduser test_user,test_user,'public'
2> go
New user added.
(return status = 0)

willa.yuan

1.日志設備已由日志段(logsegment)獨占,用戶段自然就建不上去了,日志段只存放syslogs

2.每個用戶自動屬于"public"組,"public"組不是用戶創(chuàng)建的,自動存在.

3.看看ASE系統(tǒng)管理手冊,都有介紹

whiterain

謝謝，已經搞定了