Dont forget that MSSQL (and everyone else) doesn't support standard GRANT's. you'll have to RTFM for that one :) Interbase does, the problem is, the SQL92 spec's security mechanism is braindead..... :( N "Derricutt, Mark" wrote: > > > I must concur 100% with this, and Tony's observations about MS > > SQL 7's slow, bloated GUI. Further, I second his endorsement of > > Wade's TV utility as an excellent solution to table > > Well against my better judgement, I've just installed SQL Server 7 on my > machine to look at. Our client users SQL Server 7 so that's what we're > going to support (luckily I don't actually make use of any client/server > specific things like views/stored procedures) so everything's pretty much > generic SQL (apart from a few fieldname and blob problems my app seems to > work fine with PostgreSQL on Linux as well). > > Anyway, after I do a CREATE TABLE query, how do I grant a user rights in > SQL, I tried something like: > > GRANT ALL ON test_table FOR guest; > > But that didn't seem to work. > --------------------------------------------------------------------------- > New Zealand Delphi Users group - Database List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz -- Nic Wise - Chief SCUD Launcher - Inprise/Borland New Zealand wk: 09.481.9999 x9753 cell: 021.676.418 em: [EMAIL PROTECTED] --------------------------------------------------------------------------- New Zealand Delphi Users group - Database List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
