| Author |
Topic |
|
jennypretty
Yak Posting Veteran
96 Posts |
 Posted - 2004-10-05 : 10:47:02
|
| Hello friends,I want to create a system table in SQL server 2000, such as:UserID UserRole Password------ -------- --------blah blah blahThen, I want to create a VIEW on this system table.PLEASE HELP.Jenny.The stupid question is the question you don't ask.www.single123.com |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-05 : 11:14:11
|
why system table?? why isnt't an ordinary one ok?Go with the flow & have fun! Else fight the flow  |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-05 : 22:54:04
|
wait, can we create system tables?  |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-06 : 05:16:40
|
not that i know of... maybe she found a way  Go with the flow & have fun! Else fight the flow |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-06 : 08:41:56
|
| There's an undocumented stored procedure called sp_MS_marksystemobject that can flag an object as a system object, but I don't think that's what she's looking to do. If you just want to create a view on a system table, you should have no problems as long as it's a valid SQL statement. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-06 : 08:45:29
|
| hey rob, what's the practical point of marking it a system table (object).Go with the flow & have fun! Else fight the flow |
|
|
|
jennypretty
Yak Posting Veteran
96 Posts |
Posted - 2004-10-06 : 09:44:59
|
| I still can't find the soluction to create a system table.I have a system table in access, and want to use it to create a view in sql server. In order to create a sql view, i need to create a system table first.Is there a way to create a system table in sql?thanks, guys.The stupid question is the question you don't ask.www.single123.com |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-06 : 10:11:00
|
| why do you need a system table???vievs are as easily created on user tables.create a user table in sql server with same structure as the system table in access.then put the view on it. that's all there is to it.p.s. still haven't found your pic Go with the flow & have fun! Else fight the flow |
|
|
|
jennypretty
Yak Posting Veteran
96 Posts |
Posted - 2004-10-06 : 10:49:53
|
| a system table in access is for security reason, these tables will be hidden. In sql server, I think there is not a way to create system table.Because I have reports need to be connected to system tables, so ....thanks.jenny.The stupid question is the question you don't ask.www.single123.com |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-06 : 11:00:39
|
| security is managed by users and roles in sql server. look into it.Go with the flow & have fun! Else fight the flow |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-07 : 08:38:32
|
| As spirit said, making a system object in SQL Server won't hide it from anyone. You have to control access to it with GRANT and DENY.Marking an object as "system" in SQL Server allows you to use some other undocumented commands that won't work in a non-system object. Ken Henderson'sThe Guru's Guide to SQL Server Stored Procedures, XML, and HTMLhas some good info on it. Usually though, you probably won't need to mark anything as a system object. |
|
|
|
|
CREATE SQL VIEW on System table CREATE system tabl