Thread: [Squirrel-sql-users] How to default to dbo?
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Hans L. <hlo...@kp...> - 2007-07-28 07:10:59
|
I am just trying out SQuirreL SQL for the first time, and noticed that it behaves differently than some other database management tools I am accustomed to. I am logging in to a MS SQL Server database, using the jTDS driver, as user "hloeblich". At the top level, I see the list of catalogs(i think this is the word), and I can choose one. After choosing a catalog, it looks like I am seeing a list of all usernames. The problem is that there is nothing under any of the usernames except for dbo. It seems that other tools I have used would default to dbo, and not show the other folders(if i remember correctly, this whole heirarchy level is omitted, directly under catalog shows the tables, views, etc. directories). Is there some way I can make SQuirreL behave this way. Please forgive me cause I don't completely understand the user permissioning, etc. I did not set up this database, I just have limited access under my username/login. Thank You, Hans |
From: Robert M. <rob...@gm...> - 2007-07-28 11:08:10
|
On 7/28/07, Hans Loeblich <hlo...@kp...> wrote: > I am just trying out SQuirreL SQL for the first time, and noticed that > it behaves differently than some other database management tools I am > accustomed to. > > I am logging in to a MS SQL Server database, using the jTDS driver, as > user "hloeblich". At the top level, I see the list of catalogs(i think > this is the word), and I can choose one. After choosing a catalog, it > looks like I am seeing a list of all usernames. The problem is that > there is nothing under any of the usernames except for dbo. It seems > that other tools I have used would default to dbo, and not show the > other folders(if i remember correctly, this whole heirarchy level is > omitted, directly under catalog shows the tables, views, etc. > directories). Is there some way I can make SQuirreL behave this way. > Please forgive me cause I don't completely understand the user > permissioning, etc. I did not set up this database, I just have limited > access under my username/login. There isn't a way to collapse this hiearchy. The driver tells SQuirreL that a particular table that you see in the tree is in the <username> catalog, and that the it's schema is "dbo". Theses two pieces of information are required to fully qualify a tablename in SQLServer. SQuirreL's object tree mirrors the information given by the driver for the database. You can however add a filter to remove the unused schemas from the tree. Simply right-click on the top-level node and choose "Edit Objects Filter". Then type "dbo" in the schema filter textfield. Rob |
From: Hans L. <hlo...@kp...> - 2007-07-28 23:42:09
|
Thank you, that helps a lot. Very nice feature. I do still have a few of gripes(feature requests) because I think this feature could be made much more useful. 1. Limiting Catalog Objects by prefix is not the optimal solution for me. For example, I have a catalog "ABC", and "ABC_BAK". If I only want to see ABC, there is no way to do this. I think what would be much more powerful, and probably not too difficult to implement would be the option to use regular expressions. Or even just a glob matcher (eg "ABC*" to denote anything with a "ABC" prefix). You could still do comma delimited globs even. This would be good to use for limiting schemas too, but it doesn't affect me personally since I only need to see "dbo" (and luckily no other schemas begin with dbo). I think that whatever the final decision, a *consistent* form of limiting for all three filters here would be a good thing. 2. The object filter is a nice touch, but ideally I would like to limit objects differently per catalog. All the important tables in one of my catalogs have a specific prefix, so I thought I could put this to good use. But in another catalog, there is no particular prefix on any of the tables. So if I limit it for the first catalog, then all my tables are gone in the second catalog. This makes this feature useless in my particular case. 3. The object filter seems to implement a sort of glob search, but why were "%" and "_" chosen? In my experience, the standard characters are usually "*" for zero or more of any character, and "?" to match any one character. The main problem I see with this is that "_" is a valid(and very commonly used) character for a table name. Would these suggestions be better posted to the dev list? -Hans Robert Manning wrote: > On 7/28/07, Hans Loeblich <hlo...@kp...> wrote: > >> I am just trying out SQuirreL SQL for the first time, and noticed that >> it behaves differently than some other database management tools I am >> accustomed to. >> >> I am logging in to a MS SQL Server database, using the jTDS driver, as >> user "hloeblich". At the top level, I see the list of catalogs(i think >> this is the word), and I can choose one. After choosing a catalog, it >> looks like I am seeing a list of all usernames. The problem is that >> there is nothing under any of the usernames except for dbo. It seems >> that other tools I have used would default to dbo, and not show the >> other folders(if i remember correctly, this whole heirarchy level is >> omitted, directly under catalog shows the tables, views, etc. >> directories). Is there some way I can make SQuirreL behave this way. >> Please forgive me cause I don't completely understand the user >> permissioning, etc. I did not set up this database, I just have limited >> access under my username/login. >> > > There isn't a way to collapse this hiearchy. The driver tells > SQuirreL that a particular table that you see in the tree is in the > <username> catalog, and that the it's schema is "dbo". Theses two > pieces of information are required to fully qualify a tablename in > SQLServer. SQuirreL's object tree mirrors the information given by > the driver for the database. You can however add a filter to remove > the unused schemas from the tree. Simply right-click on the top-level > node and choose "Edit Objects Filter". Then type "dbo" in the schema > filter textfield. > > Rob > |
From: Robert M. <rob...@gm...> - 2007-07-29 19:16:38
|
I added it as a feature request here: http://sourceforge.net/tracker/index.php?func=detail&aid=1763219&group_id=28383&atid=393417 Thanks! Rob On 7/28/07, Hans Loeblich <hlo...@kp...> wrote: > Thank you, that helps a lot. Very nice feature. > > I do still have a few of gripes(feature requests) because I think this > feature could be made much more useful. > > 1. Limiting Catalog Objects by prefix is not the optimal solution for > me. For example, I have a catalog "ABC", and "ABC_BAK". If I only want > to see ABC, there is no way to do this. > I think what would be much more powerful, and probably not too difficult > to implement would be the option to use regular expressions. Or even > just a glob matcher (eg "ABC*" to denote anything with a "ABC" prefix). > You could still do comma delimited globs even. > This would be good to use for limiting schemas too, but it doesn't > affect me personally since I only need to see "dbo" (and luckily no > other schemas begin with dbo). I think that whatever the final > decision, a *consistent* form of limiting for all three filters here > would be a good thing. > > 2. The object filter is a nice touch, but ideally I would like to limit > objects differently per catalog. All the important tables in one of my > catalogs have a specific prefix, so I thought I could put this to good > use. But in another catalog, there is no particular prefix on any of > the tables. So if I limit it for the first catalog, then all my tables > are gone in the second catalog. This makes this feature useless in my > particular case. > > 3. The object filter seems to implement a sort of glob search, but why > were "%" and "_" chosen? In my experience, the standard characters are > usually "*" for zero or more of any character, and "?" to match any one > character. The main problem I see with this is that "_" is a valid(and > very commonly used) character for a table name. > > Would these suggestions be better posted to the dev list? > > -Hans > > > Robert Manning wrote: > > On 7/28/07, Hans Loeblich <hlo...@kp...> wrote: > > > >> I am just trying out SQuirreL SQL for the first time, and noticed that > >> it behaves differently than some other database management tools I am > >> accustomed to. > >> > >> I am logging in to a MS SQL Server database, using the jTDS driver, as > >> user "hloeblich". At the top level, I see the list of catalogs(i think > >> this is the word), and I can choose one. After choosing a catalog, it > >> looks like I am seeing a list of all usernames. The problem is that > >> there is nothing under any of the usernames except for dbo. It seems > >> that other tools I have used would default to dbo, and not show the > >> other folders(if i remember correctly, this whole heirarchy level is > >> omitted, directly under catalog shows the tables, views, etc. > >> directories). Is there some way I can make SQuirreL behave this way. > >> Please forgive me cause I don't completely understand the user > >> permissioning, etc. I did not set up this database, I just have limited > >> access under my username/login. > >> > > > > There isn't a way to collapse this hiearchy. The driver tells > > SQuirreL that a particular table that you see in the tree is in the > > <username> catalog, and that the it's schema is "dbo". Theses two > > pieces of information are required to fully qualify a tablename in > > SQLServer. SQuirreL's object tree mirrors the information given by > > the driver for the database. You can however add a filter to remove > > the unused schemas from the tree. Simply right-click on the top-level > > node and choose "Edit Objects Filter". Then type "dbo" in the schema > > filter textfield. > > > > Rob > > > > |