[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Locking Out Users
- Subject: RE: [sqr-users] Locking Out Users
- From: "Paul Hoyte" <paul.hoyte@sharidionne.com>
- Date: Thu, 10 Jun 2004 10:15:18 -0400
- Delivery-date: Thu, 10 Jun 2004 09:18:28 -0500
- In-reply-to: <20040610134311.88002.qmail@web40806.mail.yahoo.com>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcRO8JYQH0ck6CZgQhCsMK/CppvFIgABIB0g
If you have the database privileges to issues the commands that you
referenced, then you can use these commands as part of the begin-sql
paragraph. If the privilege is not recognized by the database, then the
command will just return an error which you can trap using the on-error part
of the begin-sql statement.
Paul Hoyte
Sharidionne Inc.
(248) 752-6970
paul.hoyte@sharidionne.com
-----Original Message-----
From: sqr-users-bounces+paul.hoyte=sharidionne.com@sqrug.org
[mailto:sqr-users-bounces+paul.hoyte=sharidionne.com@sqrug.org] On Behalf Of
Upstate
Sent: Thursday, June 10, 2004 9:43 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Locking Out Users
By way of SQR, I'm attempting to connect to a databases and lock out
specific users. I'm trying to use, for example: alter user unknown account
lock
alter system kill session
However, I'm receiving invalid commands. Can I use the following commands
above, if so how, or do I need to have this in a script that I can
externally call within SQR?
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users