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

whiterain

use MCPDB
go
sp_addsegment seg_mcpdata,MCPDB,mcpdata1
go－－执行成功
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 发表
use MCPDB
go
sp_addsegment seg_mcpdata,MCPDB,mcpdata1
go－－执行成功
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"组不是用户创建的,自动存在.

3.看看ASE系统管理手册,都有介绍

whiterain

谢谢，已经搞定了