INSERT INTO SYSADM.SYSUSERAUTH

forum.sqlbase (1998-2010)
FRBhote
India
Posts: 1230
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

INSERT INTO SYSADM.SYSUSERAUTH

Post by FRBhote » 30 Mar 2009, 09:03

 Posted by:  F R Bhote 

INSERT INTO SYSADM.SYSUSERAUTH ( NAME, RESOURCEAUTH, DBAAUTH, PASSWORD )
VALUES ( :sUser, :sUserAuth1, :sUserAuth2, :sUserPW );

gives error 1102. I want to create a new database with all he users.

Dmytro G

INSERT INTO SYSADM.SYSUSERAUTH

Post by Dmytro G » 30 Mar 2009, 10:14

 Posted by:  Dmytro G 

You cannot insert directly into the tables of system catalog. Use GRANT
command instead.

FRBhote
India
Posts: 1230
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

INSERT INTO SYSADM.SYSUSERAUTH

Post by FRBhote » 30 Mar 2009, 14:59

 Posted by:  F R Bhote 

The GRANT requires the password which is encrypted in the table.

Rainer Ebert

INSERT INTO SYSADM.SYSUSERAUTH

Post by Rainer Ebert » 30 Mar 2009, 15:58

 Posted by:  Rainer Ebert 

Hi Feroz,

what about that way:
1. connnect olddb sysadm/...;
unload schema c:\dbschema.unl;

2. edit the dbschema.unl and remove everything you do not need

3. connect newdb sysadm/...;
load c:\dbschema_modified.unl;

Rainer

P.S.: Why don't you move to the new Unify webbased newsgroups?

FRBhote
India
Posts: 1230
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

INSERT INTO SYSADM.SYSUSERAUTH

Post by FRBhote » 31 Mar 2009, 07:48

 Posted by:  F R Bhote 

That's what we are doing currently. But it's a nuisance doing it for a 100+
customers this way. And all have to be done precisely on 31st March...

Those newsgroups are a pain - can't keep track of what is read in the thread
and what is not...

FRBhote
India
Posts: 1230
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

INSERT INTO SYSADM.SYSUSERAUTH

Post by FRBhote » 31 Mar 2009, 07:55

 Posted by:  F R Bhote 

Wonder where to post a general question like this on those newsgroups???

Mike Vandine

INSERT INTO SYSADM.SYSUSERAUTH

Post by Mike Vandine » 01 Apr 2009, 00:54

 Posted by:  Mike Vandine 

SQLBase/11.5 (it's not specific to 11.5, but it DOES relate to it.

Mike

Rainer Ebert

INSERT INTO SYSADM.SYSUSERAUTH

Post by Rainer Ebert » 02 Apr 2009, 16:34

 Posted by:  Rainer Ebert 

Hi Feroz!

In older times I thought and said the same. But I did so without trying to
use these newsgroups.

Some month ago I decided to use these newsgroups and I do not have problems
with them. But now i'ts a pain for me that I have to look in both newsgroups
for new threads.

To use these Unify newsgroups I registered myself as user.
Than I logged in and I'm always logged in while visiting these newsgroups.
The first thing I did than was clicking on "Mark forums read" to set all
posts to read.
Now the (yellow) icon left on a forum and/or thread shows me if there is
something new/unread.
After reading a unread thread, the yellow icon becomes white.
To directly jump to the first unread post for a thread click on the small
red icon left of the title under "Topics".
To directly jump to the lastes post for a thread click on the smal white
icon right of the username under "Last Post".
...

Regards,
Rainer

FRBhote
India
Posts: 1230
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

INSERT INTO SYSADM.SYSUSERAUTH

Post by FRBhote » 03 Apr 2009, 08:34

 Posted by:  F R Bhote 

Yup Rainer - that's fine. But here I read your post first - out there I read
my post first and have to scroll down and try and remember which posts I
have read and which ones I have not. Your post would be the last one after
scrolling all the way down...

I also note that the responses from fellow users are much better out here.

Rainer Ebert

INSERT INTO SYSADM.SYSUSERAUTH

Post by Rainer Ebert » 03 Apr 2009, 09:25

 Posted by:  Rainer Ebert 

Hi Feroz!

I understand what you mean. But having to places is not a good option.

That not true. Simply click on the little red rectangle left of the title
and you directly jump to your first unread post.

Regards,
Rainer

Return to “forum.sqlbase”

Who is online

Users browsing this forum: [Ccbot], [Google] and 0 guests